I need to rename a field in my database using a query..
I'm coding in VB and i'm link with an ODBC.. unfortunatly..
this :

ALTER TABLE NameOfTable RENAME COLUMN NameOfField TO NewNameOfField

does not work.. i keep having thi error
"Syntax error in ALTER TABLE statement"

I know the RENAME exist for foxPro but doesn't seem to work for VB
is there another way?