Skip to content
ClickHouse Docs

View

Autogenerated from ClickHouse system tables

Used for implementing views (for more information, see the CREATE VIEW query). It does not store data, but only stores the specified SELECT query. When reading from a table, it runs this query (and deletes all unnecessary columns from the query).

Syntax

CREATE VIEW name AS SELECT ...

Related

  • MaterializedView