Syntax\n------\n\nSHOW CREATE VIEW [view-name]\n\nDescription\n-----------\n\nThis 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.\n\nSHOW CREATE VIEW quotes table, column and stored function names according to the value of the sql_quote_show_create server system variable.\n\nExamples\n--------\n\nSHOW CREATE VIEW example\\G\n************************ 1. row ************************\n                View: example\n         Create View: CREATE ALGORITHM=UNDEFINED DEFINER=root@localhost SQL\nSECURITY DEFINER VIEW example AS (select t.id AS id,t.s AS s from\nt)\ncharacter_set_client: cp850\ncollation_connection: cp850_general_ci\n\nURL: https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/show/show-create-view