--显示表名 select name from dbo.sysobjects where OBJECTPROPERTY(id, N'IsUserTable') = 1 --搜索 显示 表数量 select count(name) from dbo.sysobjects where OBJECTPROPERTY(id, N'IsUserTable') = 1
--显示表名 select name from dbo.sysobjects where OBJECTPROPERTY(id, N'IsUserTable') = 1 --搜索 显示 表数量 select count(name) from dbo.sysobjects where OBJECTPROPERTY(id, N'IsUserTable') = 1