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 |
What is a function in oracle pl sql?
What does where 1 1 mean in sql?
what is the difference between cluster and non cluster index? : Sql dba
What are two parts of package ?
What is the difference between null value, zero, and blank space?
what is dbms? : Sql dba
how can i read files from a pl/sq l program
How do you run a query?
Can one improve the performance of sql*loader? : aql loader
Is sql procedural language?
Advantages and disadvantages of stored procedure?
What is the diff between Truncate table / delete <table name> purge