>DECLARE @ConstraintName nvarchar(128) >DECLARE @Command nvarchar(4000) > >DECLARE TableTemporary CURSOR LOCAL FOR > >Select 'ALTER TABLE '+tab.name+' DROP CONSTRAINT '+sysobjects.name > From SysObjects > INNER JOIN (Select [Name],[ID] From SysObjects Where XType = 'U') As Tab >On Tab.[ID] = Sysobjects.[Parent_Obj] >Inner Join sysconstraints On sysconstraints.Constid = Sysobjects.[ID] >Inner Join SysColumns Col On Col.[ColID] = sysconstraints.[ColID] And Col.[ID] = Tab.[ID] > >OPEN TableTemporary >FETCH NEXT FROM TableTemporary INTO @ConstraintName >WHILE @@fetch_status = 0 >BEGIN > SET @Command = @ConstraintName > EXEC sp_executesql @Command > FETCH NEXT FROM TableTemporary into @ConstraintName >END >>
DECLARE @ConstraintName nvarchar(128) DECLARE @Command nvarchar(max) SET @Command = '' Select @Command = @Command + 'ALTER TABLE '+tab.name+' DROP CONSTRAINT '+sysobjects.name+CHAR(13)+CHAR(10) FROM SysObjects INNER JOIN (Select [Name],[ID] From SysObjects Where XType = 'U') Tab ON Tab.[ID] = Sysobjects.[Parent_Obj] Inner Join sysconstraints On sysconstraints.Constid = Sysobjects.[ID] Inner Join SysColumns Col On Col.[ColID] = sysconstraints.[ColID] And Col.[ID] = Tab.[ID] EXEC sp_executesql @Commandbut that is a matter of preferences :-)