SingleStore DB

SHOW CREATE VIEW

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.

Example

The following example displays the output of SHOW CREATE VIEW.

CREATE VIEW count AS SELECT COUNT(*) FROM square WHERE num > 5;

SHOW CREATE VIEW count;
****
+-------+--------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+
| View  | Create View                                                                                                                                      | character_set_client | collation_connection |
+-------+--------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+
| count | CREATE DEFINER=`root`@`%` SCHEMA_BINDING=OFF VIEW `count` AS SELECT COUNT(*) AS `COUNT(*)` FROM `square` as `square`  WHERE (`square`.`num` > 0) | utf8                 | utf8_general_ci      |
+-------+--------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+

Related Topics