DROP CHECK statement
The DROP CHECK statement removes a check constraint from a table.
Compare builds this form of a DROP CHECK statement when CMPIN1 contains an unnamed check constraint.
DROP CHECK tableOwner.tableName.constraintName | This option specifies the name of the constraint to be dropped. |
|---|---|
DROP CHECK tableOwner.tableName.CHECK (constraintText) | This option specifies the name of the constraint to be dropped and the check constraint text. |
Related topic
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*