Enable a Foreign KeyALTER TABLE statement is used to enable a foreign key in SQL Server. 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 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
|