Example: Dropping a Named Constraint From a Table - Advanced SQL Engine - Teradata Database

SQL Data Definition Language Syntax and Examples

Product: Advanced SQL Engine; Teradata Database
Release Number: 17.10
Published: July 2021
ft:locale: en-US
ft:lastEdition: 2021-07-27
dita:mapPath: spp1591731285373.ditamap
dita:ditavalPath: spp1591731285373.ditaval
dita:id: B035-1144
lifecycle: previous
Product Category: Teradata Vantage™

Constraint name check_1 must exist in table_1.

     ALTER TABLE table_1 DROP CONSTRAINT check_1;