>I am converting several dozen large tables from a FP 2.6 platform to VFP 6.0. I have already moved these tables into a VFP database container and now need to add a caption and update the fieldnames to a standard naming convention. There are almost 2000 data elements and I don't want to spend the next 3 days fumbling through the database designer to set each caption manually. In that old system, I have a table that contains the "Friendly Name" (or caption) for all the data elements and 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