Managing Views in MySQL : Showing mysql view definition
Summary: in this tutorial, you will learn how to manage views in MySQL including displaying, modifying and removing views. Show view definition in MySQL MySQL provides the SHOW CREATE VIEW statement that helps you show view definition. The following is the syntax of the SHOW CREATE VIEW statement: 1 SHOW CREATE VIEW [database_name].[view_ name]; To display the definition of a … Read more