Returns an estimate of the number of rows in the specified table.
row_count(dbid, object_id [,ptnid])
the database ID where target object resides
object ID of table
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.
ANSI SQL – Compliance level: Transact-SQL extension
Any user can execute row_count.
Functions reserved_pages, used_pages
Copyright © 2005. Sybase Inc. All rights reserved. |