SQL Reference

Contents
Chapter 1
Introduction 5
About this reference 5
Where to find FileMaker documentation 5
About SQL 5
Using a FileMaker database as a data source 6
Using the ExecuteSQL function 6
Chapter 2
Supported standards 7
Support for Unicode characters 7
SQL statements 7
SELECT statement 8
SQL clauses 9
FROM clause 9
WHERE clause 10
GROUP BY clause 11
HAVING clause 11
UNION operator 12
ORDER BY clause 12
OFFSET and FETCH FIRST clauses 13
FOR UPDATE clause 14
DELETE statement 17
INSERT statement 17
UPDATE statement 19
CREATE TABLE statement 20
ALTER TABLE statement 21
CREATE INDEX statement 22
DROP INDEX statement 22
SQL expressions 23
Field names 23
Constants 23
Exponential/scientific notation 24
Numeric operators 24
Character operators 25
Date operators 25
Relational operators 25
Logical operators 27
Operator precedence 27