blob: c8c775590bf50a109276e7dd755612d2f1060888 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
|
DECLARE @cname sysname;--
SELECT @cname = dc.name
FROM sys.default_constraints dc
JOIN sys.columns c
ON c.object_id = dc.parent_object_id
AND c.column_id = dc.parent_column_id
WHERE
c.name = 'rc_patrolled'
AND c.object_id = OBJECT_ID('/*_*/recentchanges', 'U');--
IF @cname IS NOT NULL
BEGIN;--
DECLARE @sql nvarchar(max);--
SET @sql = N'ALTER TABLE /*_*/recentchanges DROP CONSTRAINT ' + @cname;--
EXEC sp_executesql @sql;--
END;--
DROP INDEX /*i*/rc_name_type_patrolled_timestamp ON /*_*/recentchanges;--
ALTER TABLE /*_*/recentchanges ALTER COLUMN rc_patrolled tinyint NOT NULL;--
ALTER TABLE /*_*/recentchanges ADD CONSTRAINT DF_rc_patrolled DEFAULT 0 FOR rc_patrolled;--
CREATE INDEX /*i*/rc_name_type_patrolled_timestamp ON /*_*/recentchanges (rc_namespace, rc_type, rc_patrolled, rc_timestamp);
|