AnsweredAssumed Answered

SQL For Accessing FileMaker Schema Info?

Question asked by trevordevore on Oct 6, 2009
Latest reply on Nov 4, 2009 by TSGal


SQL For Accessing FileMaker Schema Info?




I'm looking at adding support for FileMaker over ODBC to a product of mine. I have successfully connected to a FileMaker Pro 10 database using ODBC on OS X. I'm aware that FileMaker supports the ODBC Catalog functions such as SQLTables, SQLColumns, SQLDescribeCol, etc. I happen to have a driver that doesn't implement all of those functions though.


I'm wondering if FileMaker supports any SQL calls that will return schema info? For example, in MySQL you can use 'SHOW FULL COLUMNS FROM...' and in PostGreSQL you can use 'SELECT * FROM information_schema.columns...'. Any equivalent in FileMaker?