Filemaker 15 SQL Reference File Maker Pro Fm15 Ref

• Chapter 1 Introduction
  • About this reference
    • Where to find FileMaker documentation
  • About SQL
  • Using a FileMaker database as a data source
  • Using the ExecuteSQL function
• Chapter 2 Supported standards
  • Support for Unicode characters
  • SQL statements
    • SELECT statement
    • SQL clauses
    • FROM clause
    • WHERE clause
    • GROUP BY clause
    • HAVING clause
    • UNION operator
    • ORDER BY clause
    • OFFSET and FETCH FIRST clauses
    • FOR UPDATE clause
    • DELETE statement
    • INSERT statement
    • UPDATE statement
    • CREATE TABLE statement
    • TRUNCATE TABLE statement
    • ALTER TABLE statement
    • CREATE INDEX statement
    • DROP INDEX statement
  • SQL expressions
    • Field names
    • Constants
    • Exponential/scientific notation
    • Numeric operators
    • Character operators
    • Date operators
    • Relational operators
    • Logical operators
    • Operator precedence
  • SQL functions
    • Aggregate functions
    • Functions that return character strings
    • Functions that return numbers
    • Functions that return dates
    • Conditional functions
  • FileMaker system objects
    • FileMaker system tables
    • FileMaker system columns
  • Reserved SQL keywords
• Index