Delete Foreign Key Relationships
Applies To: SQL Server 2016
You can delete a foreign key constraint in SQL Server 2016 by using SQL Server Management Studio or Transact-SQL. Deleting a foreign key constraint removes the requirement to enforce referential integrity.
In This Topic
Before you begin:
To delete a foreign key constraint, using:
Requires ALTER permission on the table.
In Object Explorer, expand the table with the constraint and then expand Keys.
Right-click the constraint and then click Delete.
In the Delete Object dialog box, click OK.
In Object Explorer, connect to an instance of Database Engine.
On the Standard bar, click New Query.
Copy and paste the following example into the query window and click Execute.
USE AdventureWorks2012; GO ALTER TABLE dbo.DocExe DROP CONSTRAINT FK_Column_B; GO
For more information, see ALTER TABLE (Transact-SQL).