1 DECLARE @cname sysname
;--
3 SELECT @cname
= dc.
name
4 FROM sys.default_constraints dc
6 ON c.object_id
= dc.parent_object_id
7 AND c.column_id
= dc.parent_column_id
9 c.
name = 'rc_patrolled'
10 AND c.object_id
= OBJECT_ID('/*_*/recentchanges', 'U');--
14 DECLARE @
sql nvarchar(max);--
15 SET @
sql = N
'ALTER TABLE /*_*/recentchanges DROP CONSTRAINT ' + @cname
;--
16 EXEC sp_executesql @
sql;--
19 DROP INDEX /*i*/rc_name_type_patrolled_timestamp
ON /*_*/recentchanges
;--
20 ALTER TABLE /*_*/recentchanges
ALTER COLUMN rc_patrolled tinyint
NOT NULL;--
21 ALTER TABLE /*_*/recentchanges
ADD CONSTRAINT DF_rc_patrolled
DEFAULT 0 FOR rc_patrolled
;--
22 CREATE INDEX /*i*/rc_name_type_patrolled_timestamp
ON /*_*/recentchanges (rc_namespace
, rc_type
, rc_patrolled
, rc_timestamp
);