maintenance/mssql/archives/patch-externallinks-el_index_60-drop-default.sql

   1 DECLARE @sql nvarchar(max)
   2 SET @sql=''
   3
   4 SELECT @sql= @sql + 'ALTER TABLE /*_*/externallinks DROP CONSTRAINT ' + df.name + '; '
   5 FROM sys.default_constraints df
   6 JOIN sys.columns c
   7         ON c.object_id = df.parent_object_id
   8         AND c.column_id = df.parent_column_id
   9 WHERE
  10         df.parent_object_id =  OBJECT_ID('/*_*/externallinks')
  11         AND c.name = 'el_index_60';--
  12
  13 EXEC sp_executesql @sql;