Skip to content

Instantly share code, notes, and snippets.

@kr153

kr153/Row_Count_All_Tables.sql

Created July 17, 2014 12:32
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save kr153/0148a3f50080012101a3 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save kr153/0148a3f50080012101a3 to your computer and use it in GitHub Desktop.
Download ZIP
Row Count of all tables
Raw
Row_Count_All_Tables.sql
SELECT sc.NAME + '.' + ta.NAME TableName
,SUM(pa.rows) RowCnt
FROM sys.tables ta
INNER JOIN sys.partitions pa ON pa.OBJECT_ID = ta.OBJECT_ID
INNER JOIN sys.schemas sc ON ta.schema_id = sc.schema_id
WHERE ta.is_ms_shipped = 0
AND pa.index_id IN (
1
,0
)
GROUP BY sc.NAME
,ta.NAME
ORDER BY SUM(pa.rows) DESC
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment