row_count

Returns an estimate of the number of rows in the specified table.

Syntax

row_count(dbid, object_id [,ptnid] [, “option”])

Parameters

Examples

Usage

  • All erroneous conditions 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.

Standards

ANSI SQL – Compliance level: Transact-SQL extension

Permissions

Any user can execute row_count.

Related reference
reserved_pages
used_pages