# SHOW CREATE EXTENSION

The `SHOW CREATE EXTENSION` command returns the `CREATE EXTENSION` statement used to create an [Extension](https://docs.singlestore.com/db/v9.1/reference/sql-reference/procedural-sql-reference/extensions.md).

## Syntax

```sql
SHOW CREATE EXTENSION
```

## Remark

* Refer to the [Permissions Matrix](https://docs.singlestore.com/db/v9.1/reference/sql-reference/security-management-commands/permissions-matrix.md) for the required permission.

## Example

The output is formatted for readability.

```sql
SHOW CREATE EXTENSION ts9 \G

```

```output

*** 1. row ***
       Extension: ts9
Create Extension: CREATE EXTENSION `ts9` FROM 
Extension Script: -- Create both functions that make up the extension
CREATE FUNCTION ts9_to_str AS WASM FROM LOCAL INFILE "ts9.wasm" WITH WIT FROM LOCAL INFILE "ts9.wit";

CREATE FUNCTION str_to_ts9 AS WASM FROM LOCAL INFILE "ts9.wasm" WITH WIT FROM LOCAL INFILE "ts9.wit";
```

***

Modified at: June 23, 2026

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

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