SQL查询字段约束名的语句

select   b.name   from   syscolumns   a,sysobjects   b   where   a.id=object_id('tablename')   and   b.id=a.cdefault   and   a.name='field1'   and   b.name   like   'DF%'