maintenance/mssql/archives/patch-drop-ct_tag.sql

   1 -- T185355
   2 ALTER TABLE /*_*/change_tag ALTER COLUMN ct_tag INTEGER NOT NULL
   3
   4 DECLARE @sql nvarchar(max),
   5         @id sysname;--
   6
   7 SET @sql = 'ALTER TABLE /*_*/change_tag DROP CONSTRAINT ';--
   8
   9 SELECT @id = df.name
  10 FROM sys.default_constraints df
  11 JOIN sys.columns c
  12         ON c.object_id = df.parent_object_id
  13         AND c.column_id = df.parent_column_id
  14 WHERE
  15         df.parent_object_id = OBJECT_ID('/*_*/change_tag')
  16         AND c.name = 'ct_tag';--
  17
  18 SET @sql = @sql + @id;--
  19
  20 EXEC sp_executesql @sql;--
  21
  22 ALTER TABLE /*_*/change_tag DROP COLUMN ct_tag;