select name as dropname from sysobjects where xtype= 'D ' and parent_obj=(select id from sysobjects where name= 'table_name ' and xtype= 'U ') and id in (select cdefault from syscolumns where name= 'column_nane ')
我是这样写的，执行结果没问题，大家有没有更好的方法？
------解决方案--------------------
select name as dropname from sysobjects where xtype= 'D ' and id=(select cdefault from syscolumns where name= 'column_nane ' and object_id( 'tablename ')=id)