DROP CONSTRAINT

Remove a CHECK constraint from a table.

Table of contents

Synopsis

ALTER TABLE table_ident DROP CONSTRAINT check_name

Description

Removes a CHECK constraint from the table.

Warning

Removed CHECK constraints cannot be re-added to an existing table once dropped.

Parameters

table_ident:The name (optionally schema-qualified) of the table.
check_name:The name of the check constraint to be removed.