How will you a activate/deactivate integrity constraints?
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
What is a function in oracle pl sql?
What is keys and its types?
Is sql dba a good career? : SQL DBA
which command using query analyzer will give you the version of sql server and operating system? : Sql dba
What are tables in sql?
Can cursors be part of a trigger body?
What is the most common sql injection tool?
what is a composite primary key ? : Sql dba
What is string join?
What is sql server and ase?
How can I see all tables in sql?
Can I call a procedure inside a function?
how can we optimize or increase the speed of a mysql select query? : Sql dba
What is sql character function?
What is null in pl/sql?