Table, bucket, partition, and index

🗃️ SELECT

17 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...