Support DROP VIEW Statement for TPC-H Compatibility

Why it matters

This feature addresses the lack of a DROP VIEW statement in ClickHouse, enabling users to remove views as part of their database management tasks. It improves compliance with TPC-H standards and facilitates smoother schema evolution and cleanup in ClickHouse environments.

How to use it

Users can now drop existing views using the standard SQL syntax:

DROP VIEW [IF EXISTS] view_name

This statement removes the specified view from the database.