ALTER TABLE <table_name> RENAME COLUMN <col_name> TO <new_col_name>
ALTER TABLE EMP_HIST RENAME TO EMPLOYEE_HISTORY;
-- syntax
alter table table_name rename column old_name to new_name;
-- rename product_category column in products table
alter table products rename column products_category to products;