SHOW-ALTER

Name

SHOW ALTER

Description

This statement is used to display the execution of various modification tasks currently in progress

SHOW ALTER [CLUSTER | TABLE [COLUMN | ROLLUP] [FROM db_name]];

Note:

1. TABLE COLUMN: show ALTER tasks that modify columns
2. Support syntax [WHERE TableName|CreateTime|FinishTime|State] [ORDER BY] [LIMIT]
3. TABLE ROLLUP: Shows the task of creating or deleting a ROLLUP index
4. If db_name is not specified, the current default db is used
5. CLUSTER: Displays tasks related to cluster operations (only for administrators; to be implemented...)

Example

1. Display the task execution of all modified columns of the default db

    SHOW ALTER TABLE COLUMN;

2. Display the task execution status of the last modified column of a table

   SHOW ALTER TABLE COLUMN WHERE TableName = "table1" ORDER BY CreateTime DESC LIMIT 1;

3. Display the task execution of creating or deleting ROLLUP index for the specified db

   SHOW ALTER TABLE ROLLUP FROM example_db;

4. Show tasks related to cluster operations (only for administrators; to be implemented...)

   SHOW ALTER CLUSTER;

Keywords

SHOW, ALTER

Best Practice