# SHOW CREATE PROJECTION

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

The `SHOW CREATE PROJECTION` command 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.

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

***

Modified at: August 7, 2026

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

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