How will you a activate/deactivate integrity constraints?

Answers were Sorted based on User's Feedback

How will you a activate/deactivate integrity constraints?..

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

How will you a activate/deactivate integrity constraints?..

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

Post New Answer

More SQL PLSQL Interview Questions

What is the difference between subquery and correlated query?

0 Answers  

how to write utl file pkg in SQL

1 Answers   Oracle,

Why do we use cursors?

0 Answers  

What are different categories of sql commands?

0 Answers  

Give the structure of the function ?

2 Answers  

Easy way to convert tableau "IF - ELSEIF" statements to Netezza "CASE" statements.

1 Answers   CTS,

What is a sql instance vs database?

0 Answers  

what are the join types in tsql? : Transact sql

0 Answers  

Why is sql*loader direct path so fast?

0 Answers  

What is record data type?

0 Answers  

Explain correlated query work?

0 Answers  

Can you have multiple SPs with the same name on a database?

6 Answers   CGI,