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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement