justinc

FileMaker's internal schema tables & ExecuteSQL

Discussion created by justinc on Aug 7, 2012
Latest reply on Jul 21, 2014 by beverly

I have seen that FileMaker makes a few schema tables available to the FM12 ExecuteSQL statement. The two I have seen and tested are FileMaker_Tables and FileMaker_Fields. I was wondering what other tables are available. I was hoping to find one for Account information; I am trying to find out information about our account privilege sets (i.e. what account has what priv set). Is there a list of available tables out there somewhere?

 

Thanks,

J

Outcomes