108
Enable a Foreign Key
ALTER TABLE statement is used to enable a foreign key in SQL Server.
Syntax:
Parameter Explanation
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 wish to disable.
Example:
We have disabled the foreign key in previous example, now enable the foreign key.
Output:
Now the foreign key is enabled.
Next TopicDisable Foreign Key