Skip to content

Instantly share code, notes, and snippets.

@jetstreamin

jetstreamin/drop-fks.sql

Created January 24, 2019 20:56
Show Gist options
  • Save jetstreamin/77637badfa25106c12b3d2aaaa285b96 to your computer and use it in GitHub Desktop.
Save jetstreamin/77637badfa25106c12b3d2aaaa285b96 to your computer and use it in GitHub Desktop.
Download ZIP
SQL - Drop Foreign Keys From Table
Raw
drop-fks.sql
IF EXISTS (SELECT *
FROM sys.foreign_keys
WHERE object_id = OBJECT_ID(N'dbo.FK_TableName_TableName2')
AND parent_object_id = OBJECT_ID(N'dbo.TableName')
)
ALTER TABLE [dbo.TableName] DROP CONSTRAINT [FK_TableName_TableName2]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment