Which clause will allow you to disable a constraint?
A) MODIFY
B) DROP
C) DISABLE
D) STOP

Question

Which clause will allow you to disable a constraint?​
A) ​MODIFY
B) ​DROP
C) ​DISABLE
D) ​STOP

Quizplus · Accepted Answer

The DISABLE clause is used to disable a constraint in a database table. This can be useful when making changes to the table that would otherwise violate the constraint. Once the constraint has been disabled, it can be re-enabled using the ENABLE clause. The MODIFY clause is used to modify the structure of a table, the DROP clause is used to remove a table or other object from the database, and the STOP clause is not a valid clause in SQL.

Which Clause Will Allow You to Disable a Constraint?​

Which Clause Will Allow You to Disable a Constraint?