Example: Dropping a FOREIGN KEY Constraint - Teradata Vantage

Teradata® VantageCloud Lake

Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
ft:locale
en-US
ft:lastEdition
2024-12-11
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905

Drop the foreign key constraint on the column named column column_2 in table table_3.

ALTER TABLE table_1 DROP FOREIGN KEY (column_2) REFERENCES table_3;