Returns an estimate of the number of rows in the specified table.
row_count(dbid, object_id [,ptnid] [, “option”])
is the the database ID where target object resides.
is the object ID of table.
is the partition ID of interest.
Returns an estimate of the number of rows in the given object:
select row_count(5, 31000114)
Returns an estimate of the number of rows in the specified partition (with partition ID of 2323242432) of the object with object IDof 31000114:
select row_count(5, 31000114, 2323242432)
All erroneous conditions will return in a value of zero being returned.
Instead of consuming resources, row_count discards the descriptor for an object that is not already in the cache.
ANSI SQL – Compliance level: Transact-SQL extension
Any user can execute row_count.
Functions reserved_pages, used_pages
