15.10 - DROP FOREIGN KEY REFERENCES - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

prodname
Teradata Database
vrm_release
15.10
created_date
December 2015
category
Programming Reference
featnum
B035-1144-151K
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.