>>>... I want to write a program to update the caption for each field. I thought I found the solution with the ALTER TABLE command, but there does not seem to be an option to change the caption. Any Ideas?
>>
>>Hi Ken,

DBSETPROP('ALIAS.FIELD', 'Field', 'Caption', "Caption")

For renaming columns check "alter table..rename column".
>>Cetin
>More explanatory :)

DBSETPROP('CUSTOMER.CONTACT', 'Field', 'Caption', "This is my contact caption")

Cetin

Thanks Cetin

Works great. I wrote my little program and the "caption" job was done in a few seconds. I'm a VFP rookie, but I should have thought to look at that DBSETPROP command -- I knew that the caption data was stored in the DBC -- not the table.

Thanks again.