SHOW CREATE VIEW
Warning
SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.
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 29, 2025