1 out of 5 rated this helpful - Rate this topic

Delete Foreign Key Relationships

SQL Server 2012

You can delete a foreign key constraint in SQL Server 2012 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:

Security
To delete a foreign key constraint, using:

SQL Server Management Studio

Transact-SQL

Before You Begin

Security

Permissions

Requires ALTER permission on the table.

Arrow icon used with Back to Top link [Top]

Using SQL Server Management Studio

To delete a foreign key constraint

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.

Arrow icon used with Back to Top link [Top]

Using Transact-SQL

To delete a foreign key constraint

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).

Arrow icon used with Back to Top link [Top]

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD