Export (0) Print
Expand All

Delete Foreign Key Relationships

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

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

Security

Permissions

Requires ALTER permission on the table.

Arrow icon used with Back to Top link [Top]

To delete a foreign key constraint

  1. In Object Explorer, expand the table with the constraint and then expand Keys.

  2. Right-click the constraint and then click Delete.

  3. In the Delete Object dialog box, click OK.

Arrow icon used with Back to Top link [Top]

To delete a foreign key constraint

  1. In Object Explorer, connect to an instance of Database Engine.

  2. On the Standard bar, click New Query.

  3. 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]

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2015 Microsoft