-
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.
Thanks!
-
To move data from one column to other, You can use
Update contacts set accessFlags = access;
HTH
np70
-
Cool! It works perfect! Thanks a lot!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|