2 Replies Latest reply on Apr 1, 2014 3:21 AM by Fred(CH)

    SQL ALTER TABLE RENAME COLUMN

    Fred(CH)

      Hello there,

       

      I am using the FileMaker Client ODBC driver to automate field creation on a FileMaker database.

      It works just fine . But i now wanted to use the same technique to rename a field and i found this syntax on the web :

       

      ALTER TABLE table_name RENAME COLUMN old_name to new_name

       

      But i'm getting this syntax error :

      [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 FileMaker SQL reference guide, but before to give up, i wanted to have a confirmation.

       

      Thanks a lot !

       

      Bye, Fred