SQL DROP FOREIGN KEY
To remove a Foreign key from a table, use the ALTER TABLE command. The syntax to drop a primary key is:
Syntax
ALTER TABLE table_name DROP CONSTRAINT fk_name;
SQL Foreign Key Constraint
SQL Foreign Key constraint establishes a relationship between two tables by requiring values in one table’s column to match values in another table’s primary key column.