Table, bucket, partition, and index
SELECT
16 items
ALTER TABLE
Modifies an existing StarRocks table: renaming, partitioning, bucketing, columns, rollup indexes, and table properties.
CANCEL ALTER TABLE
Cancels an in-progress ALTER TABLE operation such as column modification, schema optimization, or rollup index creation.
CREATE INDEX
Creates indexes.
CREATE TABLE
Create a new table in StarRocks.
CREATE TABLE AS SELECT
CREATE TABLE AS SELECT (CTAS) creates a new table and populates it with query results, supporting synchronous and asynchronous modes.
CREATE TABLE LIKE
CREATE TABLE LIKE creates an identical empty table based on the definition of another table.
DELETE
Deletes data rows from a table based on the specified conditions.
DESC
Views the schema of a StarRocks table or external table, including its sort key and materialized view information.
DROP INDEX
DROP INDEX is used to drop a specified index on a table.
DROP TABLE
DROP TABLE is used to delete a table.
REFRESH EXTERNAL TABLE
REFRESH EXTERNAL TABLE metadata cached in StarRocks.
SHOW ALTER TABLE
Shows the execution status of ongoing ALTER TABLE operations including column changes, schema optimization, and rollup index changes.
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.
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...
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.
SHOW PARTITIONS
SHOW PARTITIONS displays partition information for a table, including common 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 AUTO_INCREMENT column attribute, which can simplify data management.