SQL ALTER TABLE RENAME COLUMN
I am using the FileMaker Client ODBC driver to automate Field creation on a FileMaker database.
ALTER TABLE table_name RENAME COLUMN old_name to new_name
[FileMaker][FileMaker] FQL0001/(1:26): There is an error in the syntax of the query.
I think that is because only few clauses of ALTER TABLE are supported by the FM Client driver as described on the SQL reference guide, but before to give up, i wanted to have a confirmation.
Thanks a lot !