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;
- Modify table comment
grammar:
MODIFY COMMENT "new table comment";
- Modify column comment
grammar:
MODIFY COLUMN col1 COMMENT "new column comment";
Example
- Change the table1's comment to table1_comment
ALTER TABLE table1 MODIFY COMMENT "table1_comment";
- 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