Hi every body,
Can you please let me know how can I modify following SQL algorithm to Disable/Enable all constraints existing in an specific table?

alter table (table name) disable constraint (constraint name)

For example if I have a table called "GIS_Data" how I can disable all constraints of it in one line command

alter table GIS_Data disable constraint .....//.......(constraint name)

Recommended Answers

All 2 Replies

Member Avatar for hfx642

I don't really think that you can.
I would write a script to create a second script which has all of your ALTER commands.
Then, run the second script.
SQL Developer may be able to, but...

yes you need to create the commands using a script.

to conform, this can't be done in a single line command.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.