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.