ALTER-TABLE-COMMENT

Name

ALTER TABLE COMMENT

Description

This statement is used to modify the comment of an existing table. The operation is synchronous. If the command returns, that means it is completed.

Syntax：

ALTER TABLE [database.]table alter_clause;

1. Modify table comment

Syntax：

MODIFY COMMENT "new table comment";

2. Modify column comment

grammar：

MODIFY COLUMN col1 COMMENT "new column comment";

Example

1. Change the table1's comment to table1_comment

ALTER TABLE table1 MODIFY COMMENT "table1_comment";

2. Change the table1's col1 comment to table1_comment

ALTER TABLE table1 MODIFY COLUMN col1 COMMENT "table1_col1_comment";

Keywords

ALTER, TABLE, COMMENT, ALTER TABLE

Best Practice