[thelist] SQL: rename column/field

[jon steele]

Hello,

I need to rename a column/field in an Access db (from ColdFusion). I
also need a WHERE clause with the statement which does this.

Is this possible? (if you know the answer, you can skip the following
detailed explanation :)  )

I need this because I have a table like this:

----------------------------------------
field1  |  field2  |  field3  |  field4 |
----------------------------------------
 blah   |   blah   |   blah   |   blah 
 blah   |   blah   |   blah   |   blah 
 blah   |   blah   |   blah   |   blah 

The field names are actually in ascending order (like XXXX_1, XXXX_2,
XXXX_3, etc.). Now if someone drops column field2, I need the field3
and field4 columns to be renamed to field2 and field 3, respectively.

(TABLE WITH DELETED FIELD2)
-------------------------------
field1  |  field2  |  field3  |
-------------------------------
 blah   |   blah   |   blah   |
 blah   |   blah   |   blah   |
 blah   |   blah   |   blah   |

Thank you,
Jon.

__________________________________________________
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/