ALTER-TABLE-COMMENT

ALTER-TABLE-COMMENT

Name

ALTER TABLE COMMENT

Description

This statement is used to modify the comment of an existing table. The operation is synchronous, and the command returns to indicate completion.

grammar：

ALTER TABLE [database.]table alter_clause;

1. Modify table comment

grammar：

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