Skip to main content
Outputs the DDL statement required to reconstruct the given view or materialized view.
SHOW VIEW Syntax
To show the view, along with all its base table dependencies (and its dependencies’ dependencies, etc.), use:
Output will be in dependency-order, with dependencies listed before views that depend on them. This allows the output to be run as a sequence of SQL commands to recreate the final view with all of its dependencies.
The response to SHOW VIEW is a single-record 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

VIEW

Optional clause to avoid ambiguity:
  • if given, and a table with the given name exists instead, the command will return an error
  • if omitted, and a table with the given name exists instead, the command will be interpreted as a SHOW TABLE statement

<schema name>

Name of the schema containing the view to show

<view name>

Name of the view whose DDL will be output

WITH OPTIONS

Optional indicator that a comma-delimited list of connection option/value assignments will follow.All valid options from Show Table can be used here.

​
Examples

To output the DDL for the example view created in the CREATE VIEW section:
SHOW VIEW Example