v.21.1Improvements

Support SHOW CREATE VIEW syntax in ClickHouse like MySQL

Official CH changelog text
Support SHOW CREATE VIEW name syntax like MySQL. #18095 (Du Chuan).
Support for SHOW CREATE VIEW name syntax similar to MySQL.

Why it matters

This feature introduces the ability to display the CREATE VIEW statement for a specified view using the SHOW CREATE VIEW command. It helps users to easily retrieve and understand the exact SQL definition of existing views, improving usability and compatibility with MySQL syntax.

How to use it

Users can obtain the view definition by running the following query:

SHOW CREATE VIEW <view_name>

Replace <view_name> with the name of the view you want to inspect.

Related resources

PreviousNext