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

What are all the common sql functions?

983

How many row comparison operators are used while working with a subquery?

997

what does it mean to have quoted_identifier on? : Sql dba

1119

What is rtm stands for?

1043

what is bdb (berkeleydb)? : Sql dba

989

Is join and inner join the same?

959

Explain the difference between sql and mysql.

1022

When do we use triggers?

1039

What is the location of pre_defined_functions.

1130

explain the difference between delete , truncate and drop commands? : Sql dba

1040

Name the operator which is used in the query for pattern matching?

909

What is record data type?

870

What is the difference between the conventional and direct path loader? : aql loader

1127

What schema means?

854

What is an escape character in sql?

997