You are welcome. There are many commands or options we do not use frequently or even have not used them at all. And it is not possible to memorize all of them.
Sure 'alter table' is not what I would want or recommend to use on the regular basis, and especially 'rename column'. When I am forced to use it (occasionally in the night maintenance routine) I personally prefer to add column first, make appropriate replacements if needed, and then drop the 'old' column.


>Hi, Yuri.
>
>>Something like this:
>>
>>use (table_name) exclu
>>alter table (table_name) RENAME COLUMN FieldName1 TO FieldName2
>
>You caught me on that one! I didn't know there was a RENAME COLUMN in VFP. That doesn't exist in SQL Server, and is probably not in ANSI SQL neither.
>
>Thanks for the tip!