📄️ 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
Removes all data from a table while preserving the table's schema. It deletes all rows in the table, making it an empty table with the same columns and constraints. Please note that, it does not release the disk space allocated to the table. To release the disk space, include the PURGE option, which is used to release the disk space allocated to the table when the truncate operation is performed.
📄️ 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:
📄️ ATTACH TABLE
Attaches an existing table to another one. The command moves the data and schema of a table from one database to another, but without actually copying the data. Instead, it creates a link that points to the original table data for accessing the data.