Skip to main content
Version: 2.5

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. If db_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;

References​