These statements allow you to create and modify tables and indexes. SQL also provides statements for performing data definition. In addition to language for querying a database, SQL provides statements for performing data manipulation, which allow you to add, update, and delete data. It is a cross-platform relational database application. SQL databases can be used as data sources in FileMaker's relationship graph, thus allowing the developer to create new layouts based on the SQL database, create, edit, and delete SQL records via FileMaker layouts and functions and reference SQL fields in FileMaker calculations and script steps. It is widely used in most other database platforms and is completely text based.

However, it is not done with a visual reputation of a database like using a relationship graph. It is a process that allows databases to perform a 'Find Request' as Filemaker developers call it. SQL has been a part of FileMaker since version nine.

FileMaker 13 has improved the tool with increased functionality.įirst off, it is important to note a few things. One of the most talked about features of FileMaker 12 when it launched in April 2012 was the inclusion of the ExecuteSQL (Structured Query Language).

What is filemaker pro 13