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
41
SQL standards compliance 7
SQL statements
ALTER TABLE 22
CREATE INDEX 22
CREATE TABLE 20
DELETE 17
DROP INDEX 23
INSERT 17
reserved keywords 36
SELECT 8
supported by client drivers 7
TRUNCATE TABLE 21
UPDATE 19
SQL_C_WCHAR data type 7
SQL-92 7
SQRT function 32
standards compliance 7
string functions 30
STRVAL function 30
subqueries 18
SUBSTR function 30
SUBSTRING function 30
syntax errors 36
system tables 34
T
table aliases 8, 9
TableId 34
TableName 34
TAN function 32
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) 20
UPDATE (SQL statement) 19
UPPER function 30
USERNAME function 30
V
VALUES (SQL clause) 17
W
WHERE (SQL clause) 10
WITH TIES (SQL clause) 13
Y
YEAR function 32