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

Thread: Renaming a column

  1. #1
    Join Date
    Mar 2001
    Posts
    82
    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)

    Thanks

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    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 http://technet.oracle.com/docs/produ...chem.htm#13290 for drop column syntax.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    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