如何找出字段默认值名称?
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)