TABLE

The TABLE expression retrieves all rows from a single table.

Syntax

TABLE <table_name>;

Details

TABLE expressions can be used anywhere that SELECT expressions are valid.

The expression TABLE t is exactly equivalent to the following SELECT expression:

SELECT * FROM t;

Examples

Using a TABLE expression as a standalone statement:

TABLE t;

 a
---
 1
 2

Using a TABLE expression in place of a SELECT expression:

TABLE t ORDER BY a DESC LIMIT 1;

 a
---
 2