ποΈ SELECT
17 items
ποΈ 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
Creates indexes.
ποΈ 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.
ποΈ DELETE
Deletes data rows from a table based on the specified conditions.
ποΈ DESC
DESC is used to view table schemas:
ποΈ 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
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.
ποΈ 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.
ποΈ SHOW PARTITIONS
SHOW PARTITIONS displays partition information, including common partitions and [temporary partitions](../../../table_design/data_distribution/Temporary_partition.md).
ποΈ 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.
