15.10 - DROP FOREIGN KEY REFERENCES - Teradata Database

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)