CNT

Core command

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 is used exactly as typed - it can be schema-qualified (e.g. CNT PUBLIC.CUSTOMER) since it is simply passed through as SELECT COUNT(*) FROM tableName. The command fails with a generic argument error if no table name is given; a non-existent table surfaces as a plain database error rather than a dedicated message.

Last modified in release 5.0.7.