统计表字段个数

来源:互联网 发布:自己怎么做淘宝优惠券 编辑:程序博客网 时间:2024/05/16 17:37
select * from syscolumns where id=object_id('BANK_FIN_PRD')
select count(name) from syscolumns where id=object_id('BANK_FIN_PRD')
 
select  'BANK_FIN_PRD', count(name) from syscolumns where id=object_id('BANK_FIN_PRD')
0 0
原创粉丝点击