# DROP PROJECTION

> **📝 Note**: This is a Preview feature.

The `DROP PROJECTION` command drops an existing projection.

## Syntax

```sql
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
  DROP PROJECTION lineitem_sort_shipdate ON lineitem;
  ```
* Database names can be referenced in the `DROP PROJECTION` command.
  ```sql
  DROP PROJECTION lineitem_sort_shipdate ON testdb1.lineitem;
  ```
* Attempt the delete operation only if a projection exists on the specified table:
  ```sql
  DROP PROJECTION IF EXISTS lineitem_sort_shipdate ON lineitem;
  ```

***

Modified at: June 11, 2026

Source: [/db/v9.1/reference/sql-reference/data-definition-language-ddl/drop-projection/](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-definition-language-ddl/drop-projection/)

(An index of the documentation is available at /llms.txt)