This post is more for record keeping. Found this useful little SQL on another site and posting it here will make it accessible to me forever.

view plain print about
1DECLARE @Sql NVARCHAR(500) DECLARE @Cursor CURSOR
2
3SET @Cursor = CURSOR FAST_FORWARD FOR
4
5SELECT DISTINCT sql = 'ALTER TABLE [' + tc2.TABLE_NAME + '] DROP [' + rc1.CONSTRAINT_NAME + ']'
6
7FROM INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS rc1
8
9LEFT JOIN INFORMATION_SCHEMA.TABLE_CONSTRAINTS tc2 ON tc2.CONSTRAINT_NAME =rc1.CONSTRAINT_NAME
10
11OPEN @Cursor FETCH NEXT FROM @Cursor INTO @Sql
12
13WHILE (@@FETCH_STATUS = 0)
14
15BEGIN
16
17Exec SP_EXECUTESQL @Sql
18
19FETCH NEXT FROM @Cursor INTO @Sql
20
21END
22
23CLOSE @Cursor DEALLOCATE @Cursor
24
25GO
26
27EXEC sp_MSForEachTable 'DROP TABLE ?'
28
29GO