How will you a activate/deactivate integrity constraints?
Answers were Sorted based on User's Feedback
Answer / muralidhar v
To Activate any integrity constraint, use Enable command
with Alter and to deactivate use disable with Alter.
To drop any constraint other than NOT NULL, use Drop
command with Alter. We can't drop not null, but we can
change it to NULL with Alter --Modify option.
Is This Answer Correct ? | 5 Yes | 1 No |
Answer / j
Alter table table_name ENABLE constraint constraint_name;
Alter table table_name DISABLE constraint constraint_name;
Is This Answer Correct ? | 0 Yes | 0 No |
What are the different tcl commands in sql?
Why we use joins in sql?
Why stored procedure is faster than query?
What is mutating table?
Is sql a scripting language?
Is it possible to include an insert statement on the same table to which the trigger is assigned?
if a string is there like s1,s2,s3,s4.How to find count of commas in this.
What is pl/sql table? Why is it used?
Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?
what is difference between procedure and function
10 Answers MCN Solutions, Wipro,
How do you drop a trigger?
what is the difference between group by and order by in sql? : Sql dba