|
/*
Obtaining the table name, schema and row count from metadata tables
User tables only
*/
select o.name as [Name], sc.name as [Type], s.row_count as [Size]
from sys.objects o
left join sys.schemas sc on sc.schema_id = o.schema_id
left join (select object_id, sum(rows) as row_count from sys.partitions
where index_id < 2
group by object_id) s on o.object_id = s.object_id
where o.type = 'U'
order by sc.name, o.name
|
By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.
If a file you wish to view isn't highlighted, and is a text file (not binary), please
let us know and we'll add colourisation support for it.
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.