TABLE - Table query

You use a table query to select all the columns of a table.

In order to read rows in the specified tables, you must either own these tables or have SELECT permission.

---

TABLE table

---

table

Name of the table (base table or view) all of whose columns are selected. The sequence, names and attributes (data type, length, precision, decimal places) of the columns of table are accepted.

The query expression TABLE table corresponds to the SELECT expression (SELECT * FROM table) (see section "SELECT expression").

Example

Display all columns in the SERVICE table:

 TABLE service