SHOW PROJECTIONS
Warning
SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.
On this page
Note
This is a Preview feature.
Shows projections created on the current database or specified table.
Syntax
SHOW PROJECTIONS [ON TABLE <table_name>];
Arguments
table_
The name of the table the projection is created on.
Remarks
-
The
SHOW PROJECTIONScommand only lists projections created on the currently selected database. -
SHOW PROJECTIONS ON TABLE <table_command shows all projections created on a specific table.name> -
The
SHOW CREATE PROJECTIONcommand shows theCREATE PROJECTIONstatement that was used to create the table. -
The
information_view provides more details about all projections created in a cluster .schema. PROJECTIONS
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_ shows all projections created on a specific table.
SHOW PROJECTIONS ON TABLE lineitem;
+-------------------------------+
| Projections_in_lineitem |
+-------------------------------+
| lineitem_sort_shipdate |
| lineitem_shard_sort_shipdate |
+-------------------------------+Last modified: April 1, 2024