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 can be schema-qualified (ALL PUBLIC.CUSTOMER). A name containing spaces or other special characters is written in double quotes (ALL "Sales Data"). BroadSQL first finds the table the name designates, the same way as DESCR: the name as typed, then in upper case, then in lower case. It then reads exactly that table, with its name quoted for the connected database, so ALL "Customer" never reads a different table named CUSTOMER. A name that no lookup finds is sent to the database as typed when it is a plain name (a synonym or an object the database resolves by itself still works); otherwise the command reports that the table does not exist. The command fails with a generic argument error if no table name is given.

Output follows the current display settings (screen, list mode, extraction) exactly like a hand-typed SELECT * would. This command applies no row limit or pagination of its own.

Last modified in release 5.3.2.