Renaming a Column in a table

To rename the columns(attributes)in a table the syntax is as follows:

syntax:

alter table table_name rename column current_column_name to new_column_name;



Example:


alter table student rename column stud_dept to dept_id;