📣

TiDB Cloud Premium is now in public preview. Unlimited growth, instant elasticity, advanced security for enterprise workloads. Try it out →

Get Started

Overview

Quick Start

Guides

Connect
Manage Resources
Data Integration
Load Data
Unload Data
Multimodal Data Analytics
Performance Tuning
Security & Reliability
Management

Troubleshooting

Tutorials

Ingest & Stream Data
Migrate Data

Reference

SQL Reference
General Reference

Support Services

Database

This page provides a comprehensive overview of database operations in TiDB Cloud Lake, 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 TiDB Cloud Lake. Make sure you have appropriate privileges before executing these commands.

Database

Database Creation & Management

Database Information

Was this page helpful?