SQL Quick count of tables

select a.name tablename , b.rows 

from sysobjects as a inner join sysindexes as b on a.id = b.id

where (a.xtype = 'u') and (b.indid in (0,1))

  and a.name in ('drop_T_Shippment',

                             'drop_T_TDHeader',

                             'drop_T_TDItem',

                             'drop_T_SFCompTrace')

order by b.rows desc;

--

SELECT

      QUOTENAME(SCHEMA_NAME(sOBJ.schema_id)) + '.' + QUOTENAME(sOBJ.name) AS [TableName]

      , SUM(sPTN.Rows) AS [RowCount]

FROM 

      sys.objects AS sOBJ

      INNER JOIN sys.partitions AS sPTN

            ON sOBJ.object_id = sPTN.object_id

WHERE

      sOBJ.type = 'U'

      AND sOBJ.is_ms_shipped = 0x0

      AND index_id < 2 -- 0:Heap, 1:Clustered

GROUP BY 

      sOBJ.schema_id

      , sOBJ.name

ORDER BY [TableName]

GO