Another way to rename a column is to use the RENAME statement together with the CREATETABLE statement with ASsubquery. This method is useful is you are changing the structure of a table rather than only renaming a column. The following statements re-create the sample table hr.job_history, renaming a column from department_id to dept_id: