# SHOW CREATE PROJECTION

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

Shows the `CREATE PROJECTION` statement that was used to create the projection.

## Syntax

```sql
SHOW CREATE PROJECTION <projection_name> FOR TABLE [database_name.]<table_name>;
```

## Arguments

**projection\_name**

The name of the projection created in 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.

## Remarks

* If `SELECT *` is used in the project list of your `CREATE PROJECTION` statement, the project list expands at `CREATE PROJECTION` time and `SHOW CREATE PROJECTION` lists out all the columns. Therefore, this expanded list does not change if the base table is altered to add new columns.

## Example

The following example displays the output of `SHOW CREATE PROJECTION`.

```sql
CREATE PROJECTION IF NOT EXISTS lineitem_sort_shipdate 
    (SHARD KEY(l_orderkey), SORT KEY(l_shipdate)) 
    AS SELECT l_shipdate, l_orderkey FROM lineitem;
```

```sql
SHOW CREATE PROJECTION lineitem_sort_shipdate FOR TABLE lineitem;

```

```output

+------------------------+---------------------------------------------+
| Projection             | Create Projection                           |
+------------------------+---------------------------------------------+
| lineitem_sort_shipdate | CREATE PROJECTION `lineitem_sort_shipdate`( | 
|                        | SHARD KEY `__SHARDKEY` (`l_orderkey`),      |
|                        | SORT KEY `l_shipdate` (`l_shipdate`)        |
|                        |   ) AS SELECT   `l_shipdate`,  `l_orderkey` |
|                        |   FROM `lineitem`                           |   
+------------------------+---------------------------------------------+

```

Database names can be referenced in the `SHOW CREATE PROJECTION` command.&#x20;

```sql
SHOW CREATE PROJECTION lineitem_sort_shipdate FOR TABLE testdb1.lineitem;
```

***

Modified at: April 2, 2024

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

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