Renaming a column Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Renaming a column

  1. #1
    Join Date
    Mar 2001
    Is there a way to rename a column in 8.1.7 ??
    Or do I have to go the intermediate table way
    (copy the data, recreate the table, copy the data back)


  2. #2
    Join Date
    Nov 2000
    AFAIK, you can't rename a column.

    1. add a field to your table with the new name.
    2. update newfield from oldfield
    3. alter table drop column oldfield

    See for drop column syntax.
    Jeff Hunter
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width