Change name of a field

  • Thread starter Thread starter Rob
  • Start date Start date
R

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!
 
Rob said:
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...
Click to expand...
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
 
Back
Top