根据表名和字段得到约束名称 创建默认值的sql

select   c.column_name,b.name   from   sysconstraints   a,sysobjects   b,INFORMATION_SCHEMA.COLUMNS   c  
  where   a.constid=b.id   and   (   b.xtype='D')  
  and   object_name(parent_obj)   =   'column_2'   and   c.table_name='column_2' and c.column_name = 'test'    
  and   c.ordinal_position=case   when   b.xtype='pk'   then   a.colid+1   else   a.colid   end 

if not exists(select name from sysobjects where name='DF_ArchiveFilesConvert_pagecount' and xtype='d'
AND parent_obj = OBJECT_ID(N'ArchiveFilesConvert')  )
AND exists(select name from syscolumns where id=object_id('ArchiveFilesConvert') and name='pagecount')

ALTER TABLE ArchiveFilesConvert  ADD CONSTRAINT DF_ArchiveFilesConvert_pagecount DEFAULT 1 FOR pagecount