SHOW CREATE VIEW
You are viewing an old version of this article. View
the current version here.
Syntax
SHOW CREATE VIEW view_name
Description
This statement shows a CREATE VIEW
statement that creates the given view, as well as the character set used by the connection when the view was created. This statement
also works with views.
SHOW CREATE VIEW
quotes table, column and stored function names according to the value of the sql_quote_show_create
server system variable.
Examples
SHOW CREATE VIEW example\G *************************** 1. row *************************** View: example Create View: CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `example` AS (select `t`.`id` AS `id`,`t`.`s` AS `s` from `t`) character_set_client: cp850 collation_connection: cp850_general_ci
With sql_quote_show_create
off:
SHOW CREATE VIEW example\G *************************** 1. row *************************** View: example Create View: CREATE ALGORITHM=UNDEFINED DEFINER=root@localhost SQL SECU RITY DEFINER VIEW example AS (select t.id AS id,t.s AS s from t) character_set_client: cp850 collation_connection: cp850_general_ci
Comments
Comments loading...
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.