Skip to main content
Get StartedConsole GuideWork With DataRelease NotesReference
Resources
VeloDB Cloud 26.x·Apache Doris 4.x (up to 4.0 supported)·"Since X.Y" tags refer to Apache Doris versionsVersion mapping

SHOW CREATE VIEW

Description​

Display the CREATE VIEW statement used to create the specified view.

Syntax​

SHOW CREATE VIEW <name>

Required Parameters​

**<name>** The name of the view to view.

Result Description​

  • View: The name of the queried view.
  • Create View: The persisted SQL statement in the database.
  • character_set_client: The value of the character_set_client system variable in the session when the view was created.
  • collation_connection: The value of the collation_connection system variable in the session when the view was created.

Access Control Requirements​

Users executing this SQL command must have at least the following privileges:

PrivilegeObjectNotes
SHOW_VIEW_PRIVTable

View information can also be queried via the INFORMATION_SCHEMA.VIEWS table.

Examples​

CREATE VIEW vtest AS SELECT 1, 'test';
SHOW CREATE VIEW vtest;

Query result:

+-------+------------------------------------------+----------------------+----------------------+
| View  | Create View                              | character_set_client | collation_connection |
+-------+------------------------------------------+----------------------+----------------------+
| vtest | CREATE VIEW `vtest` AS SELECT 1, 'test'; | utf8mb4              | utf8mb4_0900_bin     |
+-------+------------------------------------------+----------------------+----------------------+