On this page 
Warning:
As of October 4, 2019, CockroachDB v2.0 is no longer supported. For more details, refer to the Release Support Policy.
The SHOW CREATE VIEW statement shows the CREATE VIEW statement that would create a copy of the specified view.
Required Privileges
The user must have any privilege on the target view.
Synopsis
Parameters
| Parameter | Description |
|---|---|
view_name |
The name of the view for which to show the CREATE VIEW statement. |
Response
| Field | Description |
|---|---|
View |
The name of the view. |
CreateView |
The CREATE VIEW statement for creating a copy of the specified view. |
Examples
Show the CREATE VIEW statement for a view
> SHOW CREATE VIEW bank.user_accounts;
+--------------------+---------------------------------------------------------------------------+
| View | CreateView |
+--------------------+---------------------------------------------------------------------------+
| bank.user_accounts | CREATE VIEW "bank.user_accounts" AS SELECT type, email FROM bank.accounts |
+--------------------+---------------------------------------------------------------------------+
(1 row)
Show just a view's SELECT statement
To get just a view's SELECT statement, you can query the views table in the built-in information_schema database and filter on the view name:
> SELECT view_definition
FROM information_schema.views
WHERE table_name = 'user_accounts';
+---------------------------------------+
| view_definition |
+---------------------------------------+
| SELECT type, email FROM bank.accounts |
+---------------------------------------+
(1 row)
See Also
Was this helpful?
