SQL Reference

Index
A
ABS function 32
aggregate functions in SQL 28
ALL operator 26
ALTER TABLE (SQL statement) 22
AND operator 27
ANY operator 26
ATAN function 32
ATAN2 function 32
B
BaseFileName 35
BaseTableName 35
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 34
CAST function 16
CEIL function 32
CEILING function 32
character operators in SQL expressions 25
CHR function 30
COALESCE function 34
column aliases 8
constants in SQL expressions 23
container field
stored externally 21
with CREATE TABLE statement 21
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_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 32
DAYNAME function 30
DAYOFWEEK function 32
DEFAULT (SQL clause) 20
DEG function 32
DEGREES function 32
DELETE (SQL statement) 17
DISTINCT operator 8
DROP INDEX (SQL statement) 23
E
empty string, use in SELECT 15
ExecuteSQL function 6
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) 14
field names in SQL expressions 23
field repetitions 17
, 20
FieldClass 35
FieldId 35
FieldName 35
FieldReps 35
FieldType 35
FileMaker_Fields 35
FileMaker_Tables 35
FLOOR function 32
FOR UPDATE (SQL clause) 14
FROM (SQL clause) 9
FULL OUTER JOIN 10
functions in SQL expressions 28
G
GetAs function 16
GROUP BY (SQL clause) 11
H
HAVING (SQL clause) 12
HOUR function 32
I
IN operator 26
INNER JOIN 10
INSERT (SQL statement) 17
INT function 32