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%'
转载于:https://www.cnblogs.com/like0112/archive/2008/11/21/1338579.html
转载于:https://www.cnblogs.com/like0112/archive/2008/11/21/1338579.html