ALL

Displays all rows from a table

Arguments

<tableName> (mandatory) valid table name

Examples

 ALL CUSTOMER;

Notes

Displays every row of a table: ALL <tableName>.

tableName is mandatory and is used exactly as typed - it can be schema-qualified (e.g. ALL PUBLIC.CUSTOMER) since it is simply passed through as SELECT * 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.

Output follows the current display settings (screen, list mode, extraction) exactly like a hand-typed SELECT * would - there is no row limit or pagination applied by this command itself.

Last modified in release 5.0.7.