Skip to Content

 

  

Information
Limited support BMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see ALTER and BMC AMI Change Manager for Db2 13.1.

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.

GUID-FC2438B4-AC89-4BF9-B3D6-A68064AEE6D9-low.png

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

CDL-statements





 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

ALTER and BMC AMI Change Manager for Db2 12.1