Drop all constraints from database

-- Drop all constraints declare @sql varchar(1024) declare curs cursor for select 'ALTER TABLE '+tab.name+' DROP CONSTRAINT '+cons.name from sys.objects cons,sys.objects tab where cons.type in ('C', 'F', 'PK', 'UQ', 'D') and cons.parent_object_id=tab.object_id and tab.type='U' order by cons.type open curs fetch next from curs into @sql while (@@fetch_status = 0) begin exec(@sql) fetch next from curs into @sql end close curs deallocate curs