Javatpoint Logo
Javatpoint Logo

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:

SQL Enable 1

Now the foreign key is enabled.






Please Share

facebook twitter google plus pinterest

Learn Latest Tutorials


B.Tech / MCA