How To Change Column Name 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;`

Suggested for You

Trending Today