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 collation? : Sql dba

616

What is spool?

592

Explain the methods used to protect source code of pl/sql.

544

How do you create a unique index?

573

How do I run a pl sql procedure in sql developer?

513

What is record variable?

553

Can you have more than one key in a database?

507

how are mysql timestamps seen to a user? : Sql dba

564

what are all types of user defined functions? : Sql dba

548

What is the difference between between and in condition operators?

535

What is microsoft t sql?

489

define sql delete statement ? : Sql dba

556

How many sectors are in a partition?

564

What is thread join () in threading?

540

How is use pl and sql?

554