View
This page provides a comprehensive overview of view operations in Databend, organized by functionality for easy reference.
View Management
Command | Description |
---|---|
CREATE VIEW | Creates a new view based on a query |
ALTER VIEW | Modifies an existing view |
DROP VIEW | Removes a view |
View Information
Command | Description |
---|---|
DESC VIEW | Shows detailed information about a view |
SHOW VIEWS | Lists 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.