How can you change the name of a column in SQL Server?

1 year ago

William Carter

1 minute

To change a column name in SQL Server, you can use the following syntax:

ALTER TABLE table_name
RENAME COLUMN old_column_name TO new_column_name;

For example, to change the column name from “old_column” to “new_column”, you can execute the following statement:

ALTER TABLE your_table_name
RENAME COLUMN old_column TO new_column;