Sql Server Disable Foreign Key

by Online Tutorials Library July 14, 2022

Disable Foreign Key

ALTER TABLE statement is used to disable a foreign key. Once you have created a foreign key in SQL Server, you may get a situation where you are want to disable the foreign key, use the following syntax.

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:

Create a foreign key by creating two tables “products3” and “inventory” table.

  CREATE TABLE products3  ( product_id INT PRIMARY KEY,    product_name VARCHAR(50) NOT NULL,    category VARCHAR(25)  );  CREATE TABLE inventory3  ( inventory_id INT PRIMARY KEY,    product_id INT NOT NULL,    quantity INT,    min_level INT,    max_level INT,    CONSTRAINT fk_inv_product_id      FOREIGN KEY (product_id)      REFERENCES products3 (product_id)  );  

Now use the following command to disable the foreign key where foreign constraint is:

fk_inv_product_id.

  ALTER TABLE [tutoraspire].[dbo].[inventory]  NOCHECK CONSTRAINT fk_inv_product_id;   

Output:

SQL Disable 1

Now the foreign key is disabled.

Next TopicDrop Foreign Key

Sql Server Disable Foreign Key

Disable Foreign Key

Parameter explanation

Add Columns in SQL Server

AVG Function in SQL

You may also like