Alter table table_name ENABLE constraint constraint

How will you a activate/deactivate integrity constraints?

Question Posted / j

Answer Posted / 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

Please Help Members By Posting Answers For Below Questions

How to avoid duplicate records in a query?

1051

What do you understand by case manipulation functions?

1079

How do you use a while loop in pl sql?

1053

What is clause in sql?

1177

explain about mysql and its features. : Sql dba

1052

How does postgresql compare to oracle/db2/ms sql server/informix?

1093

What is sql injection owasp?

1114

What do we need to check in database testing?

1062

What is mutating error?

1006

Explain correlated query work?

1101

Explain the difference between triggers and constraints?

1024

How to write pl sql program in mysql command prompt?

1164

what is rdbms? : Sql dba

1063

What does varchar include?

992

What is a dirty read sql?

1244