On this page

ALL

Core command

Shows every row of a table, as SELECT * FROM the table would.

Syntax

ALL [<schema>.]<table>

Arguments

Argument	Required	Values	Default
`<table>`	Yes	A table name, in double quotes when it contains spaces or special characters	None
`<schema>.`	No	The schema of the table, followed by a dot	The current schema

Examples

ALL CUSTOMER;
ALL PUBLIC.CUSTOMER;
ALL "Sales Data";

Details

How the table is found

A name containing spaces or other special characters is written in double quotes (ALL "Sales Data"). BroadSQL first finds the table the same way as DESCR: the name as typed, then in upper case, then in lower case. It then reads exactly that table, its name quoted for the connected database, so ALL "Customer" never reads a different table named CUSTOMER. A plain name that no lookup finds is sent to the database as typed, so a synonym or an object the database resolves by itself still works; otherwise the command reports that the table does not exist.

Output

The rows are shown with the current display settings (screen, list mode, extraction), exactly like a typed SELECT *. The command adds no row limit or paging of its own.

CNT
DESCR
DUMP, to write the rows to a file
Console, display settings

Last modified in release 5.5.0.

Found something wrong or unclear on this page? Tell us, with the page address.

ALL