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_name

The database where the projection's base table is located. This argument is optional.

table_name

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;