Rename table columns in Access 2000

  • Thread starter Thread starter Del
  • Start date Start date
Del said:
Is there a way to rename a table column with Alter Table & Alter Column?
Click to expand...


I don't believe you can do this directly via DDL statements. You could use
ALTER TABLE ADD COLUMN to create a column with the new name, then execute an
update query to copy data from the old column to the new column, and then
use ALTER TABLE DROP COLUMN to delete the old column.

Or you could use DAO or ADOX to rename the column. For example,

' DAO example, in short form.
CurrentDb.TableDefs("MyTable").Fields("OldFieldName").Name =
"NewFieldName"
 
Back
Top