AnsweredAssumed Answered

SQL ALTER TABLE RENAME COLUMN

Question asked by Fred(CH) on Mar 31, 2014

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

Outcomes