How will you a activate/deactivate integrity constraints?
- 2 Answers
- 7945 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
Where do we use pl sql?
What is trigger point?
Which language is used in sql?
How do you rename a table in sql?
Can we change the table name in sql?
Can you have a foreign key without a primary key?
What is the maximum database size for sql express?
What do you mean by stored procedures? How do we use it?
What is materialized view. What are different methods of refresh?
what is bdb (berkeleydb)? : Sql dba
Write a unique difference between a function and a stored procedure.
Why is sql*loader direct path so fast?
who introduced sql?
What is a parameter query?
Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql
