>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 @Command >>