row_count

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

Syntax

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

Parameters

dbid – is the the database ID where target object resides.
object_id – is the object ID of table.
ptnid – is the partition ID of interest.

Examples

Example 1 – Returns an estimate of the number of rows in the given object:
```
select row_count(5, 31000114)
```
Example 2 – 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)
```

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.

Parent topic: Transact-SQL Functions

Related reference

Created May 28, 2014. Send feedback on this help topic to Technical Publications: pubs@sap.com