SHOW CREATE VIEW - Amazon Athena
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

SHOW CREATE VIEW

Shows the SQL statement that creates the specified view.

Synopsis

SHOW CREATE VIEW view_name

Examples

SHOW CREATE VIEW orders_by_date

See also CREATE VIEW and DROP VIEW.