Drop a Foreign Key
ALTER TABLE statement is used to drop a foreign key from a table once it has been created.
table_name: It specifies the name of the table where the foreign key has been created.
fk_name: It specifies the name of the foreign key that you want to remove.
In the previous example we have seen how to create a foreign key.
Use the following command to drop the foreign key called fk_inv_product_id.
Now the foreign key is dropped.