AnsweredAssumed Answered

FileMaker SQL ODBC Catalog Functions

Question asked by IanJempson on Dec 2, 2013
Latest reply on Dec 2, 2013 by user19752

Has anyone had any luck using the ODBC catalog functions listed on page 54 of the fm12_odbc_jdbc_guide ?


It lists the following, but no example syntax...


ODBC Catalog functions

The ODBC client driver supports the following Catalog functions:
1 SQLTables - catalog information is stored and reported as single part names (table name only). 1 SQLColumns
1 SQLColumnPrivileges
1 SQLDescribeCol
1 SQLGetTypeInfo


Do these provide anything more than we already get with SELECT * FROM FILEMAKER_TABLES or SELECT * FROM FILEMAKER_FIELDS ? What syntax do we need to use?