SHOW CREATE VIEW

The SHOW CREATE VIEW command shows the CREATE VIEW statement that was used to create the view.

Syntax

SHOW CREATE VIEW view_name

Arguments

view_name

The name of the view.

Remarks

  • The Create View field from the output can be used to recreate the view.

  • The output also contains information on character_set_client and collation_connection. See List of Engine Variables for more information.

  • See the Permission Matrix for the required permission.

Example

The following example displays the output of SHOW CREATE VIEW for the shipped_products view from CREATE VIEW.

SHOW CREATE VIEW shipped_products\G
*** 1. row ***
                View: shipped_products
         Create View: CREATE DEFINER=`root`@`%` SCHEMA_BINDING=OFF VIEW `shipped_products` AS SELECT `orders`.`product_id` AS `product_id`, `orders`.`quantity` AS `quantity` FROM `orders` as `orders`  WHERE (NOT ISNULL(`orders`.`quantity`))
character_set_client: utf8
collation_connection: utf8mb4_general_ci

Related Topics

Last modified:

Was this article helpful?