SQL SERVER – Find Row Count in Table – Find Largest Table in Database

SQL SERVER – Find Row Count in Table – Find Largest Table in Database

SELECT sc.name +'.'+ ta.name TableName
,SUM(pa.rows) RowCntFROM sys.tables taINNER JOIN sys.partitions paON pa.OBJECT_ID = ta.OBJECT_IDINNER JOIN sys.schemas scON ta.schema_id = sc.schema_idWHERE ta.is_ms_shipped = 0 AND pa.index_id IN (1,0)GROUP BY sc.name,ta.nameORDER BY SUM(pa.rows) DESC