17.10 - DROP FOREIGN KEY REFERENCES - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1144-171K
Language
English (United States)
Drop a foreign key reference to a key in another table. For an unnamed FOREIGN KEY REFERENCES table constraint, use this syntax:
     DROP FOREIGN KEY (referencing_column) REFERENCES 
              referenced_table_name(referenced_column_name)
For a named FOREIGN KEY REFERENCES table constraint, use this syntax:
     DROP CONSTRAINT constraint_name FOREIGN KEY 
             (referencing_column) REFERENCES 
              referenced_table_name (referenced_column_name)
(column_name_list)

Referencing column set that includes one or more columns in table that reference a primary key or alternate key in the referenced table.
table_name (column_name)

Referenced table that contains the primary key or alternate key referenced by the referencing column set and the column_name that is referenced by the referencing column set.
CONSTRAINT constraint_name
Name of the table attribute foreign key constraint.