Returns the number of records in a table.




The work area you want to check.


RECCOUNT(†) retrieves a count of a table's records from the table header, which holds information about the table structure. In contrast, COUNT with no options yields a record count by actually counting the table's records using the tableís current filter, key constraints, the setting of SET DELETED and so on. RECCOUNT(†) includes all records, even those marked as deleted, and is always instantaneous; COUNT is not.

If no table is active in the specified work area, RECCOUNT(†) returns zero.

You can use RECSIZE(†) in combination with RECCOUNT(†) to determine the approximate size, in bytes, of a table.


In some cases, the Rowset objectís rowCount(†) method will return the same value.