2 ALTER TABLE /*_*/change_tag
ALTER COLUMN ct_tag
INTEGER NOT NULL
4 DECLARE @
sql nvarchar(max),
7 SET @
sql = 'ALTER TABLE /*_*/change_tag DROP CONSTRAINT ';--
10 FROM sys.default_constraints df
12 ON c.object_id
= df.parent_object_id
13 AND c.column_id
= df.parent_column_id
15 df.parent_object_id
= OBJECT_ID('/*_*/change_tag')
16 AND c.
name = 'ct_tag';--
18 SET @
sql = @
sql + @
id;--
20 EXEC sp_executesql @
sql;--
22 ALTER TABLE /*_*/change_tag
DROP COLUMN ct_tag
;