Introspect FM schema

[tombola]

This article details

the ability to query 2 “virtual tables” for information about the schema of your FileMaker Pro v12 files

Discovering the tables and fields would allow

• cli to explore FileMaker schema
• exporting a representation of the schema
  • this could accompany python code to show expected tables
• diff of schema after amended in filemaker

[tombola]

Note: if I had a newer installation of FileMaker (19+) I could test running against base tables as per:

https://www.databuzz.com.au/changes-to-querying-the-filemaker-system-tables-in-filemaker-pro-19-4-1/