ALTER TABLE

1.ALTER TABLE NAME
ALTER TABLE [PROJECT.]OLD_TABLE_NAME RENAME TO NEW_TABLE_NAME;
2.ALTER TABLE COLUMN NAME
ALTER TABLE [PROJECT.]TABLE_NAME RENAME COLUMN OLD_COLUMN_NAME TO NEW_COLUMN_NAME;
3.ALTER TABLE COLUMN DATA TYPE
ALTER TABLE [PROJECT.]TABLE_NAME MODIFY COLUMN_NAME NEW_DATATYPE;
4.ADD COLUMN
ALTER TABLE [PROJECT.]TABLE_NAME ADD COLUMN_NAME DATATYPE;
5.DROP COLUMN
ALTER TABLE [PROJECT.]TABLE_NAME DROP COLUMN COLUMN_NAME;