How will you a activate/deactivate integrity constraints?

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How many sql statements are used? Define them.

571


What is sql injection vulnerability?

490


What is the sql case statement?

566


What is difference between stored procedure and trigger?

527


What is meant by <> in sql?

499






What is compilation error in pl sql?

499


What are different types of sql commands?

502


The in operator may be used if you know the exact value you want to return for at least one of the columns.

550


what are the differences between char and nchar? : Sql dba

589


Why do we go for stored procedures?

505


Is left join same as join?

513


What is snowflake sql?

571


What is posting?

596


how can we take a backup of a mysql table and how can we restore it. ? : Sql dba

507


What is the difference between left and left outer join?

507