I have an Access database and wish to change the name of a table column from within an ASP.NET application.
I would prefer to use an SQL statment and an OleDbCommand to do this and then ExecuteNonQuery() etc.
Two possible SQL statements are:
ALTER TABLE tablename RENAME COLUMN OldName TO NewName
ALTER TABLE tablename RENAME OldName TO NewName
Neither of these statements work and I get an SQL Syntax Error.
Does anyone know what the correct SQL statment is? I can add and remove columns OK using similar SQL statements, just can't rename a column/field!