AnsweredAssumed Answered

Getting Database structure using ExecuteSQL

Question asked by PeterGort on Nov 18, 2012
Latest reply on Nov 19, 2012 by PeterGort

For reasons that are too long to go into... I am connecting from Filemaker Pro Advanced to another Filemaker Server via ODBC. (Both are Filemaker 11 at this point).

I'd like to be able to find out the list of tables and fields that are visible through the DSN, via an SQL query. According to the ODBC Guide "SQLTables" function is a catalog function, but I can't figure out the syntax of the command to get this info. Of course once I have that, I'll need to go through each table for the list of field names and field types. Anybody know how to do this?

Outcomes