Rename column ?

[tommeekers]

Maybe this is very easy to do, but I just don't see it ... How do you rename a table using an SQL statement ? I tried using the code below and all kinds of variations on that code, but nothing seems to work. I just get an error saying 'Syntax error in instruction ALTER TABLE'.

DoCmd.RunSQL "ALTER TABLE [i]tbl_name[/i] RENAME [i]column1[/i] TO [i]column2[/i]"

 

[PHV]

I personally don't know any DDL instruction to rename a column ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886