Adding and updating columns

Renaming columns in table

Let’s say we want to rename the column name in the students table below to studentName, without changing the data in it.

SQL provides a RENAME COLUMN variant to the ALTER TABLE statement, which can be used to do so.