# DROP PROJECTION

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

The `DROP PROJECTION` command drops an existing projection.

## Syntax

```sql
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.
  ```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;
  ```

***

Modified at: June 11, 2026

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

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