# PROJECTIONS

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

This view contains information about projections.

| Column Name         | Description                                                                                                                                                              |
| ------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| `PROJECTION_SCHEMA` | The database that the projection belongs to.                                                                                                                             |
| `PROJECTION_NAME`   | The name of the projection.                                                                                                                                              |
| `BASE_TABLE_NAME`   | The name of the base table from which the projection was created.                                                                                                        |
| `CREATE_TIME`       | Timestamp when the projection was created.                                                                                                                               |
| `CREATE_USER`       | The user that created the projection.                                                                                                                                    |
| `STATUS`            | The status of the projection.Sync - the projection is currently valid for its schema.Invalid - the projection is invalid (due to dropping or changes to the table, etc.) |

***

Modified at: October 15, 2025

Source: [/db/v9.1/reference/information-schema-reference/cluster-component/projections/](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/cluster-component/projections/)

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