delete-foreign-key-relationships.md

title	description	author	ms.author	ms.date	ms.service	ms.subservice	ms.topic	helpviewer_keywords	monikerRange
Delete foreign key relationships	Learn more about how to delete foreign key from tables in the SQL Server Database Engine.	WilliamDAssafMSFT	wiassaf	08/28/2023	sql	table-view-index	how-to	foreign keys [SQL Server], deleting removing foreign keys deleting foreign keys	=azuresqldb-current||>=sql-server-2016||>=sql-server-linux-2017||=azuresqldb-mi-current||=fabric

Delete foreign key relationships

[!INCLUDE sqlserver2016-asdb-asdbmi-fabricsqldb]

You can delete a foreign key constraint in [!INCLUDE ssnoversion] by using [!INCLUDE ssManStudioFull] or [!INCLUDE tsql]. Deleting a foreign key constraint removes the requirement to enforce referential integrity.

Foreign keys reference keys in other tables, for more information, see Primary and Foreign Key Constraints.

Permissions

Requires ALTER permission on the table.

Use SQL Server Management Studio

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 select Delete.

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

Use Transact-SQL

To delete a foreign key constraint

1. In Object Explorer, connect to an instance of [!INCLUDE ssDE].

2. On the Standard bar, select New Query.

3. Copy and paste the following example into the query window and select Execute.

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

For more information, see ALTER TABLE (Transact-SQL).

Next steps

• ALTER TABLE (Transact-SQL)
• sys.key_constraints (Transact-SQL)
• Create Foreign Key Relationships
• Modify Foreign Key Relationships