How to rename a column in a table?
January 14th, 2006 By Eddie Awad
Use the ALTER TABLE command:
ALTER TABLE table_name RENAME COLUMN old_col_name TO new_col_name
One Response to “How to rename a column in a table?”
Leave a Reply
You must be logged in to post a comment.
January 16th, 2006 at 9:49 am
Consider also leaving the original table as-is and simply creating a view that changes that column name (or vice versa).