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:

  1. ALTER TABLE [database.]table alter_clause;
  1. Modify table comment

grammar:

  1. MODIFY COMMENT "new table comment";
  1. Modify column comment

grammar:

  1. MODIFY COLUMN col1 COMMENT "new column comment";

Example

  1. Change the table1’s comment to table1_comment
  1. ALTER TABLE table1 MODIFY COMMENT "table1_comment";
  1. Change the table1’s col1 comment to table1_comment
  1. ALTER TABLE table1 MODIFY COLUMN col1 COMMENT "table1_col1_comment";

Keywords

  1. ALTER, TABLE, COMMENT, ALTER TABLE

Best Practice