DROP PROJECTION

Syntax

DROP PROJECTION [IF EXISTS] <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.

• IF EXISTS: Use the IF EXISTS clause to delete a projection only if it exists on the specified table. When IF EXISTS is specified:

  • If the projection exists on the table in the ON clause, it is deleted.

  • If the projection does not exist on the specified table, the command makes no changes and completes successfully.

  • If the table in the ON clause does not exist, DROP PROJECTION returns an error.

Example

• Delete a projection.

  SQL

  Copy

  DROP PROJECTION lineitem_sort_shipdate ON lineitem;

• Database names can be referenced in the DROP PROJECTION command.

  SQL

  Copy

  DROP PROJECTION lineitem_sort_shipdate ON testdb1.lineitem;

• Attempt the delete operation only if a projection exists on the specified table:

  SQL

  Copy

  DROP PROJECTION IF EXISTS lineitem_sort_shipdate ON lineitem;