Skip to main content

View

This page provides a comprehensive overview of view operations in Databend, organized by functionality for easy reference.

View Management

CommandDescription
CREATE VIEWCreates a new view based on a query
ALTER VIEWModifies an existing view
DROP VIEWRemoves a view

View Information

CommandDescription
DESC VIEWShows detailed information about a view
SHOW VIEWSLists all views in the current or specified database
note

Views in Databend are named queries stored in the database that can be referenced like tables. They provide a way to simplify complex queries and control access to underlying data.

Explore Databend Cloud for FREE
Low-cost
Fast Analytics
Easy Data Ingestion
Elastic Scaling
Try it today