SQL Reference

Index
A
ABS function 31
aggregate functions in SQL 29
ALL operator 26
ALTER TABLE (SQL statement) 22
AND operator 27
ANY operator 26
ATAN function 31
ATAN2 function 31
B
BaseFileName 34
BaseTableName 34
BETWEEN operator 26
binary data, use in SELECT 15
blank characters 25
blank value in columns 18
BLOB data type, use in SELECT 15
C
CASE WHEN function 33
CAST function 16
CEIL function 31
CEILING function 31
character operators in SQL expressions 25
CHR function 30
COALESCE function 34
column aliases 8
constants in SQL expressions 24
container field
stored externally 21
with CREATE TABLE statement 21
with GetAs function 16
with INSERT statement 18
with PutAs function 18
with SELECT statement 16
with UPDATE statement 19
CREATE INDEX (SQL statement) 22
CREATE TABLE (SQL statement) 20
CURDATE function 33
CURRENT USER function 30
CURRENT_DATE function 33
CURRENT_TIME function 33
CURRENT_TIMESTAMP function 33
CURRENT_USER function 30
cursors in ODBC 14
CURTIME function 33
CURTIMESTAMP function 33
D
date formats 24
DATE function 33
date operators in SQL expressions 25
DATEVAL function 33
DAY function 31
DAYNAME function 30
DAYOFWEEK function 31
DEFAULT (SQL clause) 20
DEG function 31
DEGREES function 31
DELETE (SQL statement) 17
DISTINCT operator 8
documentation 5
DROP INDEX (SQL statement) 23
E
empty string, use in SELECT 15
ExecuteSQL function 6
, 7
EXISTS operator 26
EXP function 32
exponential notation in SQL expressions 25
expressions in SQL 23
EXTERNAL (SQL clause) 21
F
FETCH FIRST (SQL clause) 13
field names in SQL expressions 23
field repetitions 17
, 20
FieldClass 35
FieldId 35
FieldName 34
FieldReps 35
FieldType 35
FileMaker Server documentation 5
FileMaker_Fields 34
FileMaker_Tables 34
files, use in container fields 16
FLOOR function 32
FOR UPDATE (SQL clause) 14
FROM (SQL clause) 9
FULL OUTER JOIN 10
functions in SQL expressions 29
G
GetAs function 16
GROUP BY (SQL clause) 11