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

Database



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

Database Creation & Management

CommandDescription
CREATE DATABASECreates a new database
ALTER DATABASEModifies a database
DROP DATABASERemoves a database
USE DATABASESets the current working database
UNDROP DATABASERecovers a dropped database

Database Information

CommandDescription
SHOW DATABASESLists all databases
SHOW CREATE DATABASEShows the CREATE DATABASE statement for a database
SHOW DROP DATABASESLists dropped databases that can be recovered

Was this page helpful?