? Rename Column Name in SQL

You can rename a column in SQL using the ALTER TABLE statement along with the RENAME COLUMN clause (syntax varies slightly by SQL dialect).

? Standard SQL (PostgreSQL, MySQL 8.0+, Oracle 12c+):

ALTER TABLE table_nameRENAME COLUMN old_column_name TO new_column_name;

Example:

ALTER TABLE employeesRENAME COLUMN salary TO monthly_salary;

? SQL Server (T-SQL):

EXEC sp_rename 'table_name.old_column_name', 'new_column_name', 'COLUMN';

Example:

EXEC sp_rename 'employees.salary', 'monthly_salary', 'COLUMN';

? MySQL (older versions before 8.0):

You have to use MODIFY or CHANGE:

ALTER TABLE employeesCHANGE salary monthly_salary INT;

You must specify the column data type when using CHANGE.

? Tip:

Always check your database version and syntax compatibility before using these statements.

Would you like a complete example with CREATE TABLE, data insertion, and then column renaming?