Database

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

Database Creation & Management

Command	Description
CREATE DATABASE	Creates a new database
ALTER DATABASE	Modifies a database
DROP DATABASE	Removes a database
USE DATABASE	Sets the current working database
UNDROP DATABASE	Recovers a dropped database

Database Information

Command	Description
SHOW DATABASES	Lists all databases
SHOW CREATE DATABASE	Shows the CREATE DATABASE statement for a database
SHOW DROP DATABASES	Lists dropped databases that can be recovered

note

Database operations are foundational for organizing your data in Databend. Make sure you have appropriate privileges before executing these commands.