SQL Reference
Table Of Contents
- Chapter 1 Introduction
- 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
- SQL functions
- FileMaker system objects
- Reserved SQL keywords
- Index
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
TRUNCATE TABLE statement 21
ALTER TABLE statement 22
CREATE INDEX statement 22
DROP INDEX statement 23
SQL expressions 23
Field names 23
Constants 24
Exponential/scientific notation 25
Numeric operators 25
Character operators 25
Date operators 25
Relational operators 26
Logical operators 27
Operator precedence 28