>I need to be able to alter field names in an existing table populated with data. It appears that ALTER TABLE ALTER COLUMN will permit you do anything except that.
>
>To be clear, I import customer data from Excel and then have to make it conform to my program's table specifications. I have been able to change field widths, change character to numeric, etc, but I need to change client A,B,C field names to Custname, Address, etc without affecting the data.
>
>Any thoughts would be appreciated.
>
>--Herb Mann
You can use
ALTER TABLE ADD COLUMN newcolumnname ...
REPLACE ALL newcolumnname With oldcolumnname
ALTER TABLE DROP COLUMN oldcolumnname
Edward Pikman
Independent Consultant