use << banco a ser analisado >>
Acreditem tem gente que cria tabela com nomes indevidos....
select 'select count(*) as', Table_name as n ,'from ', Table_name as nome from INFORMATION_SCHEMA.TABLES where Table_name != 'User' order by Table_name
De uma maneira mais melhorada....
use << banco a ser analisado >>
GO
SELECT
s.[name]
, t.[name]
, p.[rows]
FROM sys.schemas s
INNER JOIN sys.tables t
ON t.[schema_id] = s.[schema_id]
INNER JOIN sys.indexes i
ON i.[object_id] = t.[object_id]
AND i.[type] IN (0,1)
INNER JOIN sys.partitions p
ON p.[object_id] = t.[object_id]
AND p.[index_id] = i.[index_id]
ORDER BY
s.[name]
, t.[name]