Drop a Foreign KeyALTER TABLE statement is used to drop a foreign key from a table once it has been created. Syntax: Parameter explanationtable_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. Example: 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. Output: Now the foreign key is dropped.
Next TopicSS Create View
|