Get table names and row count for a SQL-Server database

readme.md

First statement concatenates schema with table name while the second statement separates schema name and table name.

statement.sql

SELECT      QUOTENAME(SCHEMA_NAME(item.schema_id)) + '.' + QUOTENAME(item.name) AS TableName,
            SUM(parts.rows) AS [RowCount]
  FROM      sys.objects AS item
 INNER JOIN sys.partitions AS parts
    ON item.object_id = parts.object_id
 WHERE      item.type     = 'U'
   AND      item.is_ms_shipped = 0x0
   AND      parts.index_id     < 2 
   AND      item.name          <> 'sysdiagrams'
 GROUP BY item.schema_id,
          item.name
 ORDER BY [TableName];



SELECT      TableSchema = s.name,
            Name = t.name,
            [RowCount] = p.rows
  FROM      sys.tables t
 INNER JOIN sys.schemas s
    ON t.schema_id = s.schema_id
 INNER JOIN sys.indexes i
    ON t.object_id = i.object_id
 INNER JOIN sys.partitions p
    ON i.object_id = p.object_id
   AND i.index_id  = p.index_id
 WHERE      t.is_ms_shipped = 0 AND t.name  <> 'sysdiagrams'
 GROUP BY t.name,
          s.name,
          p.rows
 ORDER BY s.name,
          t.name;