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

Is left join and outer join same?

1043

What is the non-clustered index in sql?

1047

Where do we use pl sql?

982

What does joining a thread mean?

1001

What is relationship? How many types of relationship are there?

1148

How will you distinguish a global variable with a local variable in pl/sql?

1131

What is a parameter query?

1058

What is pls integer?

1016

Why self join is used in sql?

962

Can a trigger call a stored procedure?

1050

Can we call procedure in select statement?

1034

what is an alias command? : Sql dba

1073

Can we commit in trigger?

952

Which is faster view or stored procedure?

932

What are the sql commands?

1136