--包括系统表的个数
select count(*) from dbo.sysobjects where xtype='U' or xtype='S'--用户表的个数
select count(*) from dbo.sysobjects where xtype='U' --表名列表
select name from dbo.sysobjects where xtype='U'
select count(*) from dbo.sysobjects where xtype='U' or xtype='S'--用户表的个数
select count(*) from dbo.sysobjects where xtype='U' --表名列表
select name from dbo.sysobjects where xtype='U'
select name from dbo.sysobjects where xtype='U' and name<>'dtproperties'
select count(*) from dbo.sysobjects where xtype='U' and name<>'dtproperties'