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