Important

The SingleStore 9.1 release candidate (RC) gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 9.0 is recommended for production workloads, which can later be upgraded to SingleStore 9.1.

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