📄️ 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 COLUMN
Adds or drops a column of a table.
📄️ ALTER TABLE OPTION
Modifies the options of a table created with the default Fuse engine. For the available options you can modify, see Options.
📄️ VACUUM DROP TABLE
The VACUUM DROP TABLE command helps save storage space by permanently removing data files of dropped tables, freeing up storage space, and enabling you to manage the process efficiently. It offers options to target specific databases, set retention times, and preview the data files that will be vacuumed. To list the dropped tables of a database, use SHOW DROP TABLES.
📄️ VACUUM TABLE
The VACUUM TABLE command helps optimize 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.