Below is the syntax for the query which does exactly what the title suggests.
SELECT T.NAME AS [TABLE NAME],I.ROWS AS [ROWCOUNT]
FROM SYS.TABLES AS T INNER JOIN SYS.SYSINDEXES AS I
ON T.OBJECT_ID = I.ID AND I.INDID < 2
ORDER BY I.ROWS DESC
Showing posts with label sys.dm_db_partition_stats. Show all posts
Showing posts with label sys.dm_db_partition_stats. Show all posts
Fastest way to find row count of all tables in SQL
Below is the syntax for the query which does exactly what the title suggests.
Subscribe to:
Posts (Atom)
