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
Index 42
SQRT function 33
standards compliance 7
string functions 30
STRVAL function 30
subqueries 17
SUBSTR function 30
SUBSTRING function 30
syntax errors 37
system tables 35
T
table aliases 8, 9
TableId 35
TableName 35
TAN function 33
time formats 24
TIME function 30
timestamp formats 24
TIMESTAMPVAL function 33
TIMEVAL function 30
TODAY function 33
TRIM function 30
TRUNCATE TABLE (SQL statement) 21
U
Unicode support 7
UNION (SQL operator) 12
UNIQUE (SQL clause) 21
UPDATE (SQL statement) 19
UPPER function 30
USERNAME function 30
V
VALUES (SQL clause) 17
W
WHERE (SQL clause) 11
WITH TIES (SQL clause) 14
Y
YEAR function 33