Can we rename a column? I guess not. Here is what I am facing now -- I have a column with wrong name and a lot of data. Since I need to move those data into the right column, I plan to:
1. Add a new column with the right name to the table.
2. Move data from old column to the new one.
3. Drop the old column.
Is that right? What query can help me to accomplish #2 --- move data from old column to the new one?
Let's assume the table is Contacts, and the old column is called Access, and new one is call AccessFlags.
To move data from one column to other, You can use
Update contacts set accessFlags = access;
Cool! It works perfect! Thanks a lot!
Click Here to Expand Forum to Full Width