ποΈ 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:
ποΈ SELECT
SELECT queries data from one or more tables, views, or materialized views. The SELECT statement generally consists of the following clauses:
ποΈ SHOW ALTER TABLE
SHOW ALTER TABLE shows the execution of the ongoing ALTER TABLE operations, including:
ποΈ SHOW CREATE TABLE
Returns the CREATE TABLE statement that was used to create a given table.
ποΈ SHOW DELETE
SHOW DELETE queries historical DELETE operations that were successfully performed on Duplicate Key, Unique Key, and Aggregate tables in a specified database. For more information about data deletion, see DELETE.
ποΈ SHOW DYNAMIC PARTITION TABLES
SHOW DYNAMIC PARTITION TABLES is used to display the status of all the partitioned tables for which dynamic partitioning properties are configured in a database.
ποΈ SHOW FULL COLUMNS
SHOW FULL COLUMNS is used to show content in columns from specified tables.
ποΈ SHOW INDEX
SHOW INDEX is used to show information related to index in a table. It currently only supports bitmap index.
ποΈ SHOW PARTITIONS
SHOW PARTITIONS displays partition information, including common partitions and temporary partitions.
ποΈ SHOW TABLES
SHOW TABLES displays all tables in a StarRocks database or a database in an external data source, for example, Hive, Iceberg, Hudi, or Delta Lake.
ποΈ SHOW TABLET
SHOW TABLET displays tablet related information.
ποΈ TRUNCATE TABLE
TRUNCATE TABLE is used to truncate the specified table and partition data.
ποΈ UPDATE
Updates rows in a Primary Key table.
ποΈ AUTO_INCREMENT
Since version 3.0, StarRocks supports the AUTOINCREMENT column attribute, which can simplify data management. This topic introduces the application scenarios, usage and features of the AUTOINCREMENT column attribute.