📄️ ALTER TABLE
ALTER TABLE Modifies an existing table, including:
📄️ CANCEL ALTER TABLE
CANCEL ALTER TABLE cancels the execution of the ongoing ALTER TABLE operation, including:
📄️ CREATE INDEX
CREATE INDEX is used to create only Bitmap indexes. For usage notes and scenarios of Bitmap indexes, see Bitmap index.
📄️ CREATE TABLE
Create a new table in StarRocks.
📄️ CREATE TABLE AS SELECT
Use the CREATE TABLE AS SELECT (CTAS) statement to synchronously or asynchronously query a table and create a new table based on the query result, and then insert the query result into the new table.
📄️ CREATE TABLE LIKE
CREATE TABLE LIKE creates an identical empty table based on the definition of another table. The definition includes column definition, partitions, and table properties. You can copy an external table such as MySQL.
📄️ DELETE
Deletes data rows from a table based on the specified conditions. The table can be a partitioned or non-partitioned table.
📄️ DESC
DESC is used to view table schemas:
📄️ DROP INDEX
DROP INDEX is used to drop a specified index on a table. Currently, only bitmap index is supported in this version.
📄️ DROP TABLE
DROP TABLE is used to delete a table.
📄️ REFRESH EXTERNAL TABLE
REFRESH EXTERNAL TABLE metadata cached in StarRocks. The metadata is from tables in data lakes. This statement is used in the following scenarios: