Syntax

SHOW PROJECTIONS [ON TABLE <table_name>];

Arguments

table_name

The name of the table the projection is created on.

Remarks

• The SHOW PROJECTIONS command only lists projections created on the currently selected database.

• SHOW PROJECTIONS ON TABLE <table_name> command shows all projections created on a specific table.

• The SHOW CREATE PROJECTION command shows the CREATE PROJECTION statement that was used to create the table.

• The information_schema.PROJECTIONS view provides more details about all projections created in a workspace.

Examples

The output of the SHOW PROJECTIONS command shows all projections created on the currently selected database.

SHOW PROJECTIONS;

+----------+--------------------------------------+
| Table    | Projections                          |
+----------+--------------------------------------+
| lineitem | lineitem_sort_shipdate               |
| lineitem | lineitem_shard_sort_shipdate         |
| orders   | orders_shard_orderkey_sort_orderdate |
+----------+--------------------------------------+

The output of SHOW PROJECTIONS ON TABLE <table_name> shows all projections created on a specific table.

SHOW PROJECTIONS ON TABLE lineitem;

+-------------------------------+
| Projections_in_lineitem       |
+-------------------------------+
| lineitem_sort_shipdate        |
| lineitem_shard_sort_shipdate  |
+-------------------------------+