📄️ CREATE TABLE
Create a new table.
📄️ DROP TABLE
Deletes the table.
📄️ UNDROP TABLE
Restores the recent version of a dropped table.
📄️ RENAME TABLE
Changes the name of a table.
📄️ TRUNCATE TABLE
Empties the table completely.
📄️ DESCRIBE TABLE
Displays information about the columns in a given table.
📄️ OPTIMIZE TABLE
The objective of optimizing a table in Databend is to compact or purge its historical data in your object storage. This helps save storage space and improve query efficiency.
📄️ RESTORE TABLE
Restores a table to an earlier version with a snapshot ID or timestamp.
📄️ ANALYZE TABLE
The objective of analyzing a table in Databend is to calculate table statistics, such as distinct number of columns.