deeejay

T-SQL - Get table names and row count

Dec 26th, 2013 (edited)
343
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.31 KB | None | 0 0
  1. SELECT sc.name +'.'+ ta.name TableName
  2.  ,SUM(pa.ROWS) RowCnt
  3.  FROM sys.TABLES ta
  4.  INNER JOIN sys.partitions pa
  5.  ON pa.OBJECT_ID = ta.OBJECT_ID
  6.  INNER JOIN sys.schemas sc
  7.  ON ta.schema_id = sc.schema_id
  8.  WHERE ta.is_ms_shipped = 0 AND pa.index_id IN (1,0)
  9.  GROUP BY sc.name,ta.name
  10.  ORDER BY SUM(pa.ROWS) DESC
Advertisement
Add Comment
Please, Sign In to add comment