Skip to main content
Outputs the DDL statement required to reconstruct the given schema.
SHOW SCHEMA Syntax
The response to SHOW SCHEMA is a single-column result set with the DDL statement as the value in the DDL column, shown below with the column separators returned by kisql.

​
Parameters

CREATE

Optional keyword for clarity

SCHEMA

Optional clause to avoid ambiguity; if omitted, and a table or view exists with the given name, the command will be interpreted as a SHOW TABLE statement instead

<schema name>

Name of the schema whose contained tables’ & views’ DDL will be output; use * instead to output the DDL of all schemas, tables, & views

​
Examples

To output the DDL for the example schema created in the CREATE SCHEMA section:
SHOW SCHEMA Example
SHOW SCHEMA Output