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 |
How do you create a db file?
Can We write bulk collect statement in triggers?
Is it possible to create startup or shutdown trigger for on-schema?
what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba
what's the difference between a primary key and a unique key? : Sql dba
how to get a list of indexes of an existing table? : Sql dba
What is cross join sql?
How to recompile a already made trigger?
what is the difference between trigger and storedprocedures
Is sql a programming?
How do you get all records from 2 tables. Which join do you use?
What version is sql?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)