1 DECLARE @
sql nvarchar(max),
4 SET @
sql = 'ALTER TABLE /*_*/mwuser DROP CONSTRAINT ';--
7 FROM sys.default_constraints df
9 ON c.object_id
= df.parent_object_id
10 AND c.column_id
= df.parent_column_id
12 df.parent_object_id
= OBJECT_ID('/*_*/mwuser')
13 AND c.
name = 'user_options';--
15 SET @
sql = @
sql + @
id;--
17 EXEC sp_executesql @
sql;--
19 ALTER TABLE /*_*/mwuser
DROP COLUMN user_options
;