USE [GloriousFuture]

GO

/****** Object: StoredProcedure [dbo].[sp_drop_all_fk] Script Date: 12/07/2012 16:46:51 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER PROCEDURE [dbo].[sp_drop_all_fk]

as

declare @sql varchar(255)

declare dropsql_cursor cursor for

select 'alter table '+object_name(fkeyid)+' drop constraint '+object_name(constid)+char(10) from sysreferences

open dropsql_cursor

fetch dropsql_cursor into @sql

begin tran

while @@fetch_status=0

begin

execute(@sql)

if @@error <> 0

begin

rollback

return

end

fetch dropsql_cursor into @sql

end

deallocate dropsql_cursor

commit