SHOW CREATE VIEW
Show the definition for a view. The output includes two columns:
path: The path to the specified view.
sql_definition: The definition for the specified view.
note
You need the SELECT privilege on the view to retrieve the definition.
SHOW CREATE VIEW <view_name>
Parameters
<view_name> String
The name of the view whose definition you want to see.
Examples
Show the definition of a viewSHOW CREATE VIEW "company_data".Locations."offices_by_region"