SQL statement to view the definition of a view in the MySQL database

Environment Description:

• MySQL version: 5.5.57-log
• Operating system version: Red Hat Enterprise Linux Server Release 6.6 (Santiago)

Requirements Description:

To view a defined SQL statement for a view

Query through the Views table under the INFORMATION_SCHEMA database:

SELECT     table_name,    table_schema,    view_definition,    check_option,    is_updatablefrom      information_schema.viewsWHERE='    v_t  '\g

Query Result:

Description: Where the view_definition field is the definition of the view.

Document creation Time: March 8, 2018 10:57:18

SQL statement to view the definition of a view in the MySQL database