--显示表名
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
转载于:https://www.cnblogs.com/xushining/p/3755177.html