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 is the non-clustered index in sql?

1011

What are the uses of merge?

1120

What is faster join or subquery?

962

What is data type in sql?

923

If the application is running very slow? At what points you need to go about the database in order to improve the performance?

949

What does trigger mean in slang?

1007

how to convert numeric values to character strings? : Sql dba

1037

What are types of exception?

876

Does view contain data?

989

What action do you have to perform before retrieving data from the next result set of a stored procedure ?

2529

How do you write an index?

915

What are secondary keys?

923

How to read xml file in oracle pl sql?

862

what are the differences among rownum, rank and dense_rank? : Sql dba

985

What is pragma in pl sql?

1021