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,


Categories