ALTER TABLE table_name ADD COLUMN column_name1 column_type [COMMENT col_comment] [FIRST|AFTER column_name2]
table_name: Name of the target tablecolumn_name1: Column to be addedcolumn_type: Type of the column to be addedcol_comment: Comment for the column to be addedcolumn_name2: Column followed by the added columnALTER TABLE `TBL` ADD COLUMN `COL2` STRING COMMENT 'test' AFTER `COL1`ALTER TABLE `TBL` ADD COLUMN `COL2` STRING COMMENT 'test' FIRST
Was this page helpful?
You can also Contact sales or Submit a Ticket for help.
Help us improve! Rate your documentation experience in 5 mins.
Feedback