SQL to change a column name in MS Access

nidgep · August 7th, 2003, 08:11 AM

HI

Does anyone know the SQL Syntax to change the column names within a table in MS Access 2000?

thanks

planeswalk · August 13th, 2003, 10:52 PM

Hi,

I don't know any direct way to rename a column through SQL statements, but you can use the ALTER SQL command to add a new column with the new name and then have another ALTER statement to drop the old column. Of course, you will have to transfer data between the two columns BEFORE you issue the second ALTER statement to drop the old column. Not sure if there is any easier way to do it, though.

Cheers!

Marlon Villarama
Support Team
Web Burner Hosting
[email protected]
www.webburner.com
Toll-Free: 877-535-2876