Skip to content

Instantly share code, notes, and snippets.

View m4tt1mus's full-sized avatar
💭
I did this with GitHub's GraphQL API

Matt S m4tt1mus

💭
I did this with GitHub's GraphQL API
View GitHub Profile
-- Adapted from Jon Galloway: http://weblogs.asp.net/jgalloway/archive/2006/04/12/442616.aspx
-- This couldn't handle multiple schemas in the same table. Fixed.
-- Removed concat to widen support to earlier versions of MSSQL.
CREATE PROCEDURE [dbo].[sp_drop_constraints]
@database [sysname] = NULL,
@table [sysname],
@verbose [bit] = 0
AS