查找sqlserver数据库中表的数量sql语句
select count(name) as usertableCounts from 数据库名.dbo.sysobjects where xtype='U' and name<> 'dtproperties'
经过测试可用。
no pays,no gains!
select count(name) as usertableCounts from 数据库名.dbo.sysobjects where xtype='U' and name<> 'dtproperties'
经过测试可用。