SHOW CREATE VIEW
On this page
Shows the CREATE VIEW
statement that was used to create the view.
Syntax
SHOW CREATE VIEW view_name
Arguments
view_
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_
andset_ client 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_
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: May 20, 2025