SQL Server 得到数据库中所有表的名称及数据条数
- WBOYOriginal
- 2016-06-07 17:44:00968browse
b.name as tablename ,c.row_count as datacount from sys.indexes a ,sys.objects b ,sys.dm_db_partition_stats c b.b.c.a.index_id = c.index_id b.is_ms_shipped b.name as tablename ,a.rowcnt as datacount from sysindexes a ,sysobjects b where a.i
b.name as tablename , c.row_count as datacount from sys.indexes a , sys.objects b , sys.dm_db_partition_stats c b.b.c.a.index_id = c.index_id b.is_ms_shipped b.name as tablename , a.rowcnt as datacount from sysindexes a , sysobjects b where a.id = b.id (b.id, ) = 0 ，香港服务器租用，美国服务器，香港虚拟主机
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：（一）绪论Next article： 移动Sql Server数据库的脚本