How will you a activate/deactivate integrity constraints?
- 2 Answers
- 7964 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
What is procedure in pl sql?
how to check server status with 'mysqladmin'? : Sql dba
What is view? Can we update view
How many times can we commit in a loop?
What is primary key sql?
What is online transaction processing (oltp)?
What are different sql data types?
What is the difference between join and natural join?
Where is sql database stored?
What type of database is cloud sql?
What are the different ways to optimize a sql query?
What is java sql package?
Is sql port 1433 encrypted?
Can one improve the performance of sql*loader? : aql loader
ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..
