SQL Server Drop Foreign key code example

Example 1: drop foreign key

ALTER TABLE table_name
DROP CONSTRAINT fk_name;

Example 2: how to remove foreign key constraint in sql

USE AdventureWorks2012;  
GO  
ALTER TABLE dbo.DocExe   
DROP CONSTRAINT FK_Column_B;   
GO

Example 3: sql foreign key

CREATE TABLE orders (
id int NOT NULL,
user_id int,
product_id int,
PRIMARY KEY (id),
FOREIGN KEY (user_id) REFERENCES users(id),
FOREIGN KEY (product_id) REFERENCES products(id)
);

Example 4: SQL Server Drop Foreign key

ALTER TABLE Orders

DROP CONSTRAINT FK_PersonOrder;

Tags:

Misc Example

Related