从table / sys.tables中选择row_count和tablename? [英] Select row_count and tablename from a table/sys.tables?
本文介绍了从table / sys.tables中选择row_count和tablename?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
如何获取所有tables_name,来自数据库的记录数?
示例: - 我正在寻找像
1)SELECT COUNT(*),来自Sys.tables的Table_name
2)SELECT COUNT(*),Tbl_Employee FROM Tbl_Employee
解决方案
SELECT OBJECT_NAME(id),max(rows)FROM sys.sysindexes group by id
Right
但在我看来,完美答案应该是: -
SELECT OBJECT_NAME (id),max(rows) FROM sys.sysindexes
WHERE OBJECT_SCHEMA_NAME (id)<> ' sys'
group by id order by OBJECT_NAME (id) ASC
选择 coulumnName,count(*)来自 sys.sysindexes
SELECT OBJECT_NAME(id),行FROM sys.sysindexes
How to get all tables_name,count of record from a database?
Example:-I am looking for something like
1)SELECT COUNT(*),Table_name from Sys.tables
2)SELECT COUNT(*),Tbl_Employee FROM Tbl_Employee
解决方案
SELECT OBJECT_NAME(id),max(rows) FROM sys.sysindexes group by id
Right
But in my opinion perfect answer should be:-
SELECT OBJECT_NAME(id),max(rows) FROM sys.sysindexes WHERE OBJECT_SCHEMA_NAME(id)<>'sys' group by id order by OBJECT_NAME(id) ASC
select coulumnName,count(*) from sys.sysindexes
SELECT OBJECT_NAME(id),rows FROM sys.sysindexes
这篇关于从table / sys.tables中选择row_count和tablename?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文