FileMaker

UPDATE:2023-06-13
https://help.claris.com/en/sql-reference.pdf

On this page

ODBC

  1. Driver install
    <Installer>/Extras/xDBC/ODBC Client Driver Installer/FMODBC_Installer_Win64.msi
  2. DSN Setting
    Windows : ODBC data source administrator

Method

  1. [System]Get TableName
    SELECT "TableId","TableName","BaseFileName" FROM "FileMaker_Tables"
    or SELECT "TableName" FROM "FileMaker_Tables"
  2. [System]Get Columns
    SELECT "FieldId","FieldName","FieldType" FROM "FileMaker_Fields" WHERE TableName ='<Table Name>'