# SHOW PROJECTIONS

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

Shows projections created on the current database or specified table.

## Syntax

```sql
SHOW PROJECTIONS [ON TABLE <table_name>];
```

## Arguments

**table\_name**

The name of the table the projection is created on.

## Remarks

* The `SHOW PROJECTIONS` command only lists projections created on the currently selected database.&#x20;
* `SHOW PROJECTIONS ON TABLE <table_name>` command shows all projections created on a specific table.
* The `SHOW CREATE PROJECTION` command shows the `CREATE PROJECTION` statement that was used to create the table.
* The `information_schema.PROJECTIONS` view provides more details about all projections created in a  workspace.

## Examples

The output of the `SHOW PROJECTIONS` command shows all projections created on the currently selected database.

```sql
SHOW PROJECTIONS;

```

```output

+----------+--------------------------------------+
| Table    | Projections                          |
+----------+--------------------------------------+
| lineitem | lineitem_sort_shipdate               |
| lineitem | lineitem_shard_sort_shipdate         |
| orders   | orders_shard_orderkey_sort_orderdate |
+----------+--------------------------------------+

```

The output of `SHOW PROJECTIONS ON TABLE <table_name>` shows all projections created on a specific table.

```sql
SHOW PROJECTIONS ON TABLE lineitem;

```

```output

+-------------------------------+
| Projections_in_lineitem       |
+-------------------------------+
| lineitem_sort_shipdate        |
| lineitem_shard_sort_shipdate  |
+-------------------------------+
```

***

Modified at: April 1, 2024

Source: [/cloud/reference/sql-reference/show-commands/show-projections/](https://docs.singlestore.com/cloud/reference/sql-reference/show-commands/show-projections/)

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