Important

The SingleStore 9.1 release candidate (RC) is available now. It will be promoted to general availability (GA) soon and at that time it will be renamed to SingleStore 10.

In the interim, SingleStore 9.1 RC can be used to preview, evaluate, and provide feedback on the new and upcoming features in SingleStore 10, while SingleStore 9.0 is recommended for production workloads.

SHOW CREATE EXTENSION

Syntax

SQL

SHOW CREATE EXTENSION

Remark

Refer to the Permissions Matrix for the required permission.

Example

The output is formatted for readability.

SQL

SHOW CREATE EXTENSION ts9 \G

*** 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";