0 Replies Latest reply on Mar 31, 2014 2:16 AM by Fred(CH)

    SQL ALTER TABLE RENAME COLUMN

    Fred(CH)

      Title

      SQL ALTER TABLE RENAME COLUMN

      Post

           Hello there,

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

           It works just fine smiley. 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 crying : 
      [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 !
            
           Bye, Fred