Member Avatar for Behseini

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)
Edited by Behseini because: Typo
  • 3 Contributors
  • 2 Replies
  • 82 Views
  • 14 Hours Discussion Span
  • Latest Post Latest Post by debasisdas
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...

Member Avatar for debasisdas

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.