CNT

Displays result of a SELECT COUNT(*) for a table

Arguments

<tableName> (mandatory) valid table name

Examples

 CNT CUSTOMER;

Notes

Counts the rows of a table: CNT <tableName>.

tableName is mandatory and can be schema-qualified (CNT PUBLIC.CUSTOMER). A name containing spaces or other special characters is written in double quotes (CNT "Sales Data"). The table is found exactly as ALL finds it (the name as typed, then in upper case, then in lower case), and the count runs on that table, with its name quoted for the connected database. A name that no lookup finds is sent to the database as typed when it is a plain name; otherwise the command reports that the table does not exist. The command fails with a generic argument error if no table name is given.

Last modified in release 5.3.2.