How to get all CREATE VIEW statements with a single query?
This Query is used to get the definition of a single view:
show view db.tablename;
metadatateradata
How to get all CREATE VIEW statements with a single query?
This Query is used to get the definition of a single view:
show view db.tablename;
Best Answer
You'll need to use the catalog views (h/t to Dieter for alerting me to truncation of
RequestText
inTablesV
):