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

Why do we use view in sql?

959

What are the different types of tables in sql?

1007

How do I debug a stored procedure?

1113

What is sql*loader and what is it used for? : aql loader

1174

how to fetch alternate records from a table? : Sql dba

1112

Does pl sql work in mysql?

980

Why do we use subquery?

1011

What is a trigger in sql?

1202

How you can copy a file to file content and file to pl/sql table in advance pl/sql?

1145

What can I use instead of union in sql?

965

What are sql objects?

1075

What is set serveroutput on in pl sql?

1293

What are local and global Indexes and where they are useful.

1442

What are stored procedures used for?

1001

What is transaction control language (tcl)?

1139