Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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
Advertisement
Add Comment
Please, Sign In to add comment