SHOW ALTER TABLE
Description
Shows the execution of ongoing ALTER TABLE tasks.
Syntax
SHOW ALTER TABLE {COLUMN | ROLLUP} [FROM <db_name>]
Parameters
-
COLUMN | ROLLUP
-
If COLUMN is specified, this statement shows tasks for modifying columns. If you need to nest a WHERE clause, the supported syntax is
[WHERE TableName|CreateTime|FinishTime|State] [ORDER BY] [LIMIT]
. -
If ROLLUP is specified, this statement shows tasks for creating or deleting ROLLUP indexes.
-
-
db_name
: optional. Ifdb_name
is not specified, the current database is used by default.
Examples
Example 1: Show column modification tasks in the current database.
SHOW ALTER TABLE COLUMN;
Example 2: Show the latest column modification task of a table.
SHOW ALTER TABLE COLUMN WHERE TableName = "table1"
ORDER BY CreateTime DESC LIMIT 1;
Example 3: Show tasks for creating or deleting ROLLUP indexes in a specified database.
SHOW ALTER TABLE ROLLUP FROM example_db;