DROP a CONSTRAINT in a table in Teradata

You can drop a constraint in a table by specifying the name of the constraint.

Syntax:
ALTER TABLE tbl_name DROP CONSTRAINT constraint_name


Example:
ALTER TABLE tbl_employee DROP CONSTRAINT pk_1