DROP PROJECTION

Note

This is a Preview feature.

The DROP PROJECTION command drops an existing projection.

Syntax

DROP PROJECTION <projection_name> ON [database_name.]<table_name>

Arguments

  • projection_name: The name of the projection that was created using 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

  • Delete a projection.

    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:

Was this article helpful?