How will you a activate/deactivate integrity constraints?
- 2 Answers
- 7995 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How do I start sql profiler?
write an sql query to find names of employee start with 'a'? : Sql dba
How do I count rows in sql query?
What is the purpose of the primary key?
What is the difference between a primary key and a unique key?
Does sql profiler affect performance?
Can we perform dml in function?
What are all the different normalization?
What are the different parts of a package?
What is query execution plan in sql?
Why is theta join required?
What is the difference between explicit and implicit cursors in oracle?
What can I use instead of union in sql?
Write a sql query to convert all character to uppercase after hypen.
Difference between global and parameter variables?
