How to Rename a Column in SQL?

Use `ALTER TABLE table_name RENAME COLUMN old_column_name TO new_column_name;`

In MySQL 8.0+, use `ALTER TABLE table_name RENAME COLUMN old_column_name TO new_column_name;`

In older MySQL versions, use `ALTER TABLE table_name CHANGE old_column_name new_column_name data_type;`

In SQL Server, use `EXEC sp_rename ‘table_name.old_column_name’, ‘new_column_name’, ‘COLUMN’;`

In PostgreSQL, use `ALTER TABLE table_name RENAME COLUMN old_column_name TO new_column_name;`

In Oracle, use `ALTER TABLE table_name RENAME COLUMN old_column_name TO new_column_name;`

In SQLite, use `ALTER TABLE table_name RENAME COLUMN old_column_name TO new_column_name;`

Replace `table_name`, `old_column_name`, and `new_column_name` with your actual names

Include the column data type when using `CHANGE` in MySQL

Check for dependent views, queries, or procedures after renaming the column

Suggested for You

Trending Today