16.20 - DROP FOREIGN KEY REFERENCES - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Syntax and Examples

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-24
dita:mapPath
wkf1512081455740.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval
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.