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.