📄️ 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
Shows information about the columns in a given table.
📄️ OPTIMIZE TABLE
Optimizing a table in Databend involves compacting or purging historical data to save storage space and enhance query performance.
📄️ FLASHBACK TABLE
Flashback a table to an earlier version with a snapshot ID or timestamp, only involving metadata operations, making it a fast process.
📄️ ANALYZE TABLE
The objective of analyzing a table in Databend is to calculate table statistics, such as a distinct number of columns.
📄️ ALTER TABLE
Adds or drops a column of a table.
📄️ VACUUM TABLE
The VACUUM TABLE command helps to optimize the system performance by freeing up storage space through the permanent removal of historical data files from a table. This includes: