DROP PROJECTION
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.
Drops an existing projection.
Syntax
DROP PROJECTION <name> ON [database_name.]<table_name>;
Arguments
name
The name of the projection that was created in the CREATE PROJECTION
command.
database_
The database where the projection's base table is located.
table_
The name of the table the projection is created on.
Example
DROP PROJECTION lineitem_sort_shipdate ON lineitem;
Database names can be referenced in the DROP PROJECTION
command.
DROP PROJECTION lineitem_sort_shipdate ON testdb1.lineitem;
Last modified: April 1, 2024