v.21.2New Features

Support EXISTS VIEW syntax

Official CH changelog text
Support EXISTS VIEW syntax. #18552 (Du Chuan).
Add support for the EXISTS VIEW syntax in ClickHouse.

Why it matters

This feature allows users to easily check for the existence of a view in the database, improving workflow efficiency and script automation by enabling conditional logic based on view presence.

How to use it

Use the EXISTS VIEW syntax in SQL queries to check if a specific view exists. For example:
EXISTS VIEW <view_name>

Related resources

PreviousNext