Change name of a field

[Rob]

Sorry for the simple nature of the question, but how does one
programmatically change the name of a field in a table? The MS ADO
Help pages are quite obscure and don't seem to answer this very basic
question...

Thanks in advance!

 

[Gary Walter]

Sorry for the simple nature of the question, but how does one
programmatically change the name of a field in a table? The MS ADO
Help pages are quite obscure and don't seem to answer this very basic
question...

programmatically...not that I recall

you can use ALTER query to add
a column with new name

then run update query to transfer
values from old field to new field

then ALTER query to drop
old column

http://www.devguru.com/Technologies/jetsql/quickref/alter_table.html

 

[Rob]

programmatically...not that I recall

you can use ALTER query to add
a column with new name

then run update query to transfer
values from old field to new field

then ALTER query to drop
old column

http://www.devguru.com/Technologies/jetsql/quickref/alter_table.html

Thanks. This probably moves more data around than I really want, but
it definitely does the trick!