--显示表名 select name from dbo.sysobjects where OBJECTPROPERTY(id, N'IsUserTable') = 1 --搜索 显示 表数量 select count(name) from dbo.sysobjects where OBJECTPROPERTY(id, N'IsUserTable') = 1
xushining 2014-05-27 15:16 原文
--显示表名 select name from dbo.sysobjects where OBJECTPROPERTY(id, N'IsUserTable') = 1 --搜索 显示 表数量 select count(name) from dbo.sysobjects where OBJECTPROPERTY(id, N'IsUserTable') = 1