FileMaker 15 SQL リファレンスガイド

Transcription

1 FileMaker 15 SQL

2 FileMaker, Inc. All Rights Reserved. FileMaker, Inc Patrick Henry Drive Santa Clara, California FileMaker FileMaker Go FileMaker, Inc. FileMaker WebDirect FileMaker, Inc. FileMaker FileMaker, Inc. FileMaker E URL E URL Acknowledgments URL FileMaker, Inc. 01

3 1 5 5 FileMaker 5 SQL 5 FileMaker 6 ExecuteSQL Unicode 7 SQL 7 SELECT 8 SQL 9 FROM 9 WHERE 10 GROUP BY 11 HAVING 11 UNION 12 ORDER BY 12 OFFSET FETCH FIRST 13 FOR UPDATE 14 DELETE 17 INSERT 17 UPDATE 19 CREATE TABLE 20 TRUNCATE TABLE 21 ALTER TABLE 22 CREATE INDEX 22 DROP INDEX 23 SQL

4 4 SQL FileMaker 34 FileMaker 34 FileMaker 35 SQL 36 39

5 1 FileMaker Pro SQL SQL FileMaker ODBC JDBC ODBC JDBC FileMaker Pro [ExecuteSQL] FileMaker Pro SQL FileMaker ODBC JDBC SQL FileMaker Pro [ExecuteSQL] SELECT 1 FileMaker Pro ODBC JDBC 1 FileMaker Pro ODBC JDBC SQL 1 FileMaker Pro Advanced FileMaker Pro FileMaker Pro FileMaker Pro Advanced FileMaker 1 FileMaker Pro [ ] > [ ] 1 FileMaker Server Admin Console [ ] > [FileMaker Server ] 1 FileMaker SQL SQL SELECT SQL SQL FileMaker SQL 2

6 1 6 FileMaker FileMaker ODBC JDBC FileMaker ODBC JDBC FileMaker FileMaker ODBC JDBC SQL FileMaker FileMaker ODBC JDBC FileMaker ODBC JDBC FileMaker ODBC JDBC SQL ExecuteSQL FileMaker Pro [ExecuteSQL] [ExecuteSQL] [ExecuteSQL] [ExecuteSQL] [ExecuteSQL] [ExecuteSQL] [ExecuteSQL] SELECT 8 SELECT ExecuteSQL ({}) SQL-92 ISO [ExecuteSQL] ODBC/JDBC [ExecuteSQL] FileMaker Pro

7 2 FileMaker SQL FileMaker ODBC JDBC SQL FileMaker Pro [ExecuteSQL] SELECT ODBC JDBC FileMaker FileMaker FileMaker Pro FileMaker Server 1 ODBC ODBC 3.0 Level 1 1 JDBC JDBC ODBC JDBC SQL-92 SQL-92 Unicode ODBC JDBC Unicode API Unicode ASCII Unicode SQL_C_WCHAR SQL ODBC JDBC SQL 1 SELECT8 1 DELETE17 1 INSERT17 1 UPDATE19 1 CREATE TABLE20 1 TRUNCATE TABLE21 1 ALTER TABLE22 1 CREATE INDEX22 1 DROP INDEX23 FileMaker ODBC SQL JDBC SQL FileMaker ODBC JDBC SQL ODBC JDBC FileMaker

8 2 8 SELECT SELECT SELECT * 1.05 SELECT SELECT [DISTINCT] {* [[AS] ],...} FROM [ ],... [ WHERE 1 2 ] [ GROUP BY {,...}] [ HAVING 1 2 ] [ UNION [ALL] (SELECT...)] [ ORDER BY { [DESC ASC]},...] [ OFFSET n {ROWS ROW} ] [ FETCH FIRST [ n [ PERCENT ] ] { ROWS ROW } {ONLY WITH TIES } ] [ FOR UPDATE [OF {,...}]] ([]) SELECT " " AS " " FROM " ".. DISTINCT : SELECT DISTINCT " " FROM " "

9 2 9 SQL ODBC JDBC SQL SQL FROM9 WHERE10 GROUP BY11 HAVING11 UNION12 ORDER BY12 OFFSET13 SELECT FileMaker Pro 1 FileMaker Pro 1 20,000,000 2 SELECT 1 FETCH FIRST13 FOR UPDATE14 SQL SELECT FROM FROM SELECT FROM [ ] [, [ ]] ExecuteSQL SELECT " " from " " FROM E E. SELECT : SELECT * FROM " " "E", " " "F" WHERE "E"." " = "F"." " (=)

10 2 10 INNER JOIN : SELECT * FROM " " INNER JOIN " " ON " "." " = " "." " 2 LEFT OUTER JOIN SELECT * FROM " " LEFT OUTER JOIN " " ON " "." " = " "." " 1 RIGHT OUTER JOIN 1 FULL OUTER JOIN WHERE WHERE WHERE WHERE SELECT 2,000,000 SELECT " "," " FROM " " WHERE " " >= WHERE WHERE 1 IS NULL WHERE NOT 2 SELECT WHERE

11 2 11 GROUP BY GROUP BY 1 GROUP BY GROUP BY FROM FROM 1 SELECT " ", SUM ( " " ) FROM " " GROUP BY " " 1 HAVING HAVING 20,000,000 HAVING SELECT 2 20,000,000 SELECT " ", SUM ( " " ) FROM " " GROUP BY " " HAVING SUM ( " " ) >

12 2 12 UNION UNION SELECT 1 1 SELECT ALL (UNION ALL) SELECT UNION [ALL] SELECT UNION SELECT : SELECT " ", " ", " " FROM " " UNION SELECT " ", " ", " " FROM " " SELECT SELECT " ", " " FROM " " UNION SELECT " ", " " FROM " " ORDER BY ORDER BY SELECT ORDER BY ORDER BY { [DESC ASC]},... (ASC) SELECT SELECT " ", " ", " " FROM " " ORDER BY " ", " " SELECT " ", " ", " " FROM " " ORDER BY 2, FileMaker SQL FileMaker Pro Unicode

13 2 13 OFFSET FETCH FIRST OFFSET FETCH FIRST OFFSET OFFSET SELECT 0 FETCH FIRST OFFSET 1 OFFSET FETCH FIRST SELECT OFFSET OFFSET FETCH FIRST OFFSET OFFSET [ OFFSET n {ROWS ROW} ] n n ROWS ROW FETCH FIRST FETCH FIRST FETCH FIRST [ n [ PERCENT ] ] { ROWS ROW } {ONLY WITH TIES } ] n n 1 PERCENT n 1 n PERCENT ROWS ROW WITH TIES ORDER BY WITH TIES ORDER BY FETCH 26 SELECT SELECT " ", " ", " " FROM " " ORDER BY " ", " " OFFSET 25 ROWS 10 SELECT " ", " ", " " FROM " " ORDER BY " ", " " OFFSET 25 ROWS FETCH FIRST 10 ROWS ONLY

14 ORDER BY SELECT " ", " ", " " FROM " " ORDER BY " ", " " OFFSET 25 ROWS FETCH FIRST 10 ROWS WITH TIES FOR UPDATE FOR UPDATE SQL FOR UPDATE [OF ] 2,000,000 SELECT * FROM " " WHERE " " > FOR UPDATE OF " ", " ", " "

15 2 15 SQL SELECT 'CatDog' FROM " " SELECT 999 FROM " " SELECT DATE ' ' FROM " " SELECT TIME '02:49:03' FROM " " SELECT TIMESTAMP ' :49:03' FROM " " SELECT " " FROM " " SELECT DISTINCT " " FROM " " SELECT " " FROM " " SELECT DISTINCT " " FROM " " SELECT " " FROM " " SELECT DISTINCT " " FROM " " SELECT " " FROM " " SELECT DISTINCT " " FROM " " SELECT " " FROM " " SELECT DISTINCT " " FROM " " BLOB a SELECT " " FROM " " SELECT GETAS(" ", 'JPEG') FROM " " * SELECT * FROM " " SELECT DISTINCT * FROM " " a. BLOB FileMaker FileMaker (*) SELECT * FROM " " SELECT DISTINCT * FROM " " 1 FileMaker SELECT * FROM WHERE c ='' SELECT * FROM WHERE c <>'' 1 SELECT GetAs() : CAST() GetAs()

16 2 16 : CAST() GetAs() JPEG GetAS( " ", 'JPEG') SELECT SELECT < > QuickTime SELECT CAST() : SELECT CAST( " " AS VARCHAR) FROM " " 1 FileMaker Pro SELECT SQL_VARCHAR 1 FileMaker Pro SELECT 1 SELECT? (FileMaker Pro.dat GetAs() DEFAULT DEFAULT SELECT GetAs(" ", 'DEFAULT') FROM " " FileMaker Pro GetAs() : 1 [ ] > [ ] GetAs() FILE : SELECT GetAs(" ", 'FILE') FROM " " 1 [ ] > [ ] - MAC OS X GetAs() snd : SELECT GetAs(" ", 'snd') FROM " "

17 [ ] > [ ] 1 : SELECT GetAs(" ", 'JPEG') FROM " " 'GIFf' Graphics Interchange Format 'PNTG' MacPaint 'JPEG' '.SGI' 'JP2' JPEG 2000 'TIFF' 'PDF' Portable Document Format 'TPIC' Targa 'PNGf' Bitmap '8BPS' PhotoShop (PSD) DELETE DELETE DELETE DELETE FROM [ WHERE { } ] WHERE WHERE DELETE DELETE FROM " " WHERE " " = 'E10001' DELETE WHERE E INSERT INSERT 1 1 SELECT INSERT INSERT INTO [(,...)] VALUES (,...) VALUES [4]

18 2 18 (') 2 : 'Don''t' (()) INSERT INTO " " ( " ", " ", " ", " ", " " ) VALUES (' ', ' ', 'E22345', , DATE ' ') INSERT INSERT PutAs() INSERT INTO " " (" ") VALUES(? AS '. ') FILE PutAs() PutAs (col, ' ') 16 : CAST() GetAs() SELECT SELECT INSERT SELECT INSERT INSERT INTO " 1" ( " ", " ", " ", " ", " " ) SELECT " ", " ", " ", " ", " " FROM " " WHERE " " = 'D050' INSERT SELECT INSERT SELECT 2 2 SELECT INSERT INSERT/UPDATE ODBC JDBC SELECT INSERT SELECT

19 2 19 UPDATE UPDATE UPDATE UPDATE SET =,...[ WHERE { } ] 1 (') 2 : 'Don''t' (()) WHERE UPDATE UPDATE " " SET " " =32000, " " =1 WHERE " " = 'E10001' UPDATE WHERE E UPDATE " " SET " " = (SELECT avg ( " " ) from " " ) WHERE " " = 'E10001' E10001 UPDATE PutAs() UPDATE " " SET (" ") =? AS '. ' FILE PutAs() PutAs(col, ' ') 16 : CAST() GetAs()

20 2 20 CREATE TABLE CREATE TABLE CREATE TABLE CREATE TABLE ( [,...]) [[ ]] [DEFAULT ] [UNIQUE NOT NULL PRIMARY KEY GLOBAL] [EXTERNAL [SECURE OPEN ]] 1 CREATE TABLE CREATE TABLE " " (ID INT PRIMARY KEY, " " VARCHAR (20), " " VARCHAR (20)) 1 CREATE TABLE : EMPLOYEE_ID INT[4] LASTNAME VARCHAR(20)[4] 1 NUMERICDECIMALINTDATETIMETIMESTAMPVARCHARCHARACTER VARYINGBLOBVARBINARYLONGVARBINARY BINARY VARYING NUMERIC DECIMAL : DECIMAL(10,0)TIME TIMESTAMP : TIMESTAMP(6)VARCHAR CHARACTER VARYING : VARCHAR(255) 1 DEFAULT USERUSERNAMECURRENT_USERCURRENT_DATECURDATE CURRENT_TIMECURTIMECURRENT_TIMESTAMPCURTIMESTAMP NULL 1 UNIQUE FileMaker [ ] 1 NOT NULL FileMaker [ ] FileMaker Pro [ ] [ ] [ ]

21 BLOBVARBINARY BINARY VARYING 1 EXTERNAL FileMaker FileMaker Pro [ ] SECUREOPEN (/) SQL CREATE TABLE "T1" ("C1" VARCHAR, "C2" VARCHAR (50), "C3" VARCHAR (1001), "C4"VARCHAR (500276)) NOT NULL CREATE TABLE "T1NN" ("C1" VARCHAR NOT NULL, "C2" VARCHAR (50) NOT NULL, "C3" VARCHAR (1001) NOT NULL, "C4" VARCHAR (500276) NOT NULL) CREATE TABLE "T2" ("C1" DECIMAL, "C2" DECIMAL (10,0), "C3" DECIMAL (7539,2), "C4" DECIMAL (497925,301)) CREATE TABLE "T3" ("C1" DATE, "C2" DATE, "C3" DATE, "C4" DATE) CREATE TABLE "T4" ("C1" TIME, "C2" TIME, "C3" TIME, "C4" TIME) CREATE TABLE "T5" ("C1" TIMESTAMP, "C2" TIMESTAMP, "C3" TIMESTAMP, "C4" TIMESTAMP) CREATE TABLE "T6" ("C1" BLOB, "C2" BLOB, "C3" BLOB," C4" BLOB) CREATE TABLE "T7" ("C1" BLOB EXTERNAL 'Files/MyDatabase/' SECURE) CREATE TABLE "T8" ("C1" BLOB EXTERNAL 'Files/MyDatabase/' OPEN 'Objects') TRUNCATE TABLE TRUNCATE TABLE TRUNCATE TABLE TRUNCATE TABLE WHERE TRUNCATE TABLE TRUNCATE TABLE FileMaker 301

22 2 22 ALTER TABLE ALTER TABLE 1 ALTER TABLE ALTER TABLE ADD [COLUMN] ALTER TABLE DROP [COLUMN] ALTER TABLE ALTER [COLUMN] SET DEFAULT ALTER TABLE ALTER [COLUMN] DROP DEFAULT ALTER TABLE SQL ALTER TABLE " " ADD " 1" VARCHAR ALTER TABLE " " DROP " 1" ALTER TABLE " " ALTER " " SET DEFAULT 'FileMaker' ALTER TABLE " " ALTER " " DROP DEFAULT SET DEFAULT DROP DEFAULT CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX ON. CREATE INDEX ON ( ) CREATE INDEX 1 FileMaker FileMaker [ ] [ ] FileMaker [ ] [ ] FileMaker [ ] [ ] FileMaker CREATE INDEX

23 2 23 CREATE INDEX ON " "." " DROP INDEX DROP INDEX DROP INDEX DROP INDEX ON. DROP INDEX ON ( ) FileMaker SELECT FileMaker [ ] [ ] [ ] PREVENT INDEX CREATION DROP INDEX ON " "." " SQL SELECT WHERE HAVING ORDER BY

24 2 24 * (') 2 : 'Don''t' ODBC JDBC FileMaker ({}) ODBC/JDBC 1 {D ' '} 1 {T '14:35:10'} 1 {TS ' :35:10'} FileMaker (DTTS) FileMaker SQL-92 ({}) ISO 1 DATE 'YYYY-MM-DD' 1 TIME 'HH:MM:SS' 1 TIMESTAMP 'YYYY-MM-DD HH:MM:SS' FileMaker Pro [ExecuteSQL] ({}) SQL-92 ISO ' ' 1.05 DATE ' ' { D ' ' } {06/05/2016} {06/05/16} : 2 ODBC/JDBC SQL-92 TIME '14:35:10' { T '14:35:10' } {14:35:10} TIMESTAMP ' :35:10' { TS ' :35:10'} {06/05/ :35:10} {06/05/16 14:35:10} 2 FileMaker [ 4 ] : 2 ODBC/JDBC SQL-92

25 2 25 SELECT "column1" / 3.4E+7 FROM "table1" WHERE "calc" < 3.4E-6 * "column2" +-*/ ^ ** (+) (-) + + ' ' - - ' ' DATE ' ' DATE ' ' DATE' ' DATE ' ' SELECT " ", " " + 30 AS " " FROM " " SELECT " ", " " - 30 AS " " FROM " "

26 2 26 = <> > >= < <= LIKE NOT LIKE IS NULL IS NOT NULL BETWEEN IN NOT IN EXISTS ANY =<>>>=< <= =Any In ALL =, <>, >, >=, <, <= SELECT " "." " FROM " " WHERE " "." " = 'SP-1' SELECT " "." " FROM " " WHERE " "." " <> 125 SELECT " "." " FROM " " WHERE " "." " > SELECT " "." " FROM " " WHERE " "." " < '12:00:00' SELECT " "." " FROM " " WHERE " "." " LIKE '% ' SELECT " "." " FROM " " WHERE " "." " NOT LIKE '% ' SELECT " "." " FROM " " WHERE " "." " IS NULL SELECT " "." " FROM " " WHERE " "." " IS NOT NULL SELECT " "." " FROM " " WHERE " "." " BETWEEN 1 AND 10

27 2 27 SELECT COUNT ( " "." " ) AS " " FROM " " WHERE " "." " IN (50,250,100) SELECT COUNT ( " "." " ) AS " " FROM " " WHERE " "." " NOT IN (50,250,100) SELECT COUNT ( " "." " ) AS " " FROM " " WHERE " "." " NOT IN (SELECT " "." " FROM " " WHERE " "." " = 'SP-4') SELECT * FROM " " WHERE EXISTS (SELECT " "." " FROM " " WHERE " "." " IS NOT NULL) SELECT * FROM " " WHERE " "." " = ANY (SELECT " "." " FROM " " WHERE " "." " = 'SP-1') SELECT * FROM " " WHERE " "." " = ALL (SELECT " "." " FROM " " WHERE " "." " IS NULL) 2 AND OR = AND = 1 NOT NOT ( = AND = 1) SELECT * FROM " " WHERE " "." " NOT LIKE '% ' AND " "." " > SELECT * FROM " " WHERE ( " "." " LIKE '% ' OR " "." " > ) AND " "." " = 'SP-1'

28 ^, ** 3 *, / 4 +, - 5 =, <>, <, <=, >, >=, Like, Not Like, Is Null, Is Not Null, Between, In, Exists, Any, All 6 Not 7 AND 8 OR WHERE (" " > OR " " > (DATE ' ') AND " " = 'D101' AND D101 4,000,000 : WHERE (" " > OR " " > DATE ' ') AND " " = 'D101' 4,000, D101 SQL FileMaker SQL 1 SELECT AVG("" ) AVG("" * 1.07) DISTINCT : COUNT (DISTINCT " ")

29 2 29 SUM AVG COUNT MAX MIN SUM () AVG () COUNT () COUNT COUNT COUNT(*) MAX () MIN () SELECT SUM ( " "." " ) AS " " FROM " " SELECT AVG ( " "." " ) AS " " FROM " " SELECT COUNT ( " "." " ) AS " " FROM " " SELECT MAX ( " "." " ) AS " " FROM " " WHERE " "." " < SELECT MIN ( " "." " ) AS " " FROM " " WHERE " "." " > FileMaker 8309 ([Expressions involving aggregations are not supported]) SUM ROUND SELECT ROUND(SUM( " " ), 0) FROM " " SELECT SUM(ROUND( " ", 0)) FROM " "

30 2 30 CHR ASCII 1 CHR(67) C CURRENT_USER DAYNAME ID RTRIM RTRIM(' ABC ') ABC TRIM TRIM(' ABC ') ABC LTRIM LTRIM(' ABC') ABC UPPER UPPER('Allen') ALLEN LOWER LOWER('Allen') allen LEFT LEFT('Mattson',3) Mat MONTHNAME RIGHT RIGHT(Mattson', 4) tson SUBSTR SUBSTRING SUBSTR('Conrad', 2, 3) onr SUBSTR('Conrad', 2) onrad SPACE SPACE(5) STRVAL STRVAL('Woltman') Woltman STRVAL(5 * 3) 15 STRVAL(4 = 5) False STRVAL(DATE ' ') TIME TIMEVAL USERNAME USER ID 9:49 TIME() 21:49:00 TIME() SQL CURRENT_TIME

31 2 31 SELECT CHR(67) + SPACE(1) + CHR(70) FROM " " SELECT RTRIM(' ' + " "." " ) AS " " FROM " " SELECT TRIM(SPACE(1) + " "." " ) AS " " FROM " " SELECT LTRIM(' ' + " "." " ) AS " " FROM " " SELECT UPPER( " "." " ) AS " " FROM " " SELECT LOWER( " "." " ) AS " " FROM " " SELECT LEFT( " "." ", 5) AS " " FROM " " SELECT RIGHT( " "." ", 7) AS " " FROM " " SELECT SUBSTR( " "." ", 2, 2) + SUBSTR( " "." ", 4, 2) AS " " FROM " " SELECT SUBSTR( " "." ", 2) + SUBSTR( " "." ", 4) AS " " FROM " " SELECT SPACE(2) + " "." " AS " " FROM " " SELECT STRVAL('60506') AS " " FROM " " WHERE " "." " = 1 ABS ATAN ATAN2 CEIL CEILING x y DEG DEGREES DAY DAY(DATE '2016/01/30') 30 DAYOFWEEK 1 7 DAYOFWEEK(DATE ' ') 7 MOD 2 MOD(10, 3) 1 EXP FLOOR HOUR (e)

32 2 32 INT INT(6.4321) 6 LENGTH LENGTH('ABC') 3 MONTH MONTH(DATE '2016/01/30') 1 LN LOG MAX 2 MAX(66, 89) 89 MIN 2 MIN(66, 89) 66 MINUTE NUMVAL PI RADIANS pi NUMVAL('123') 123 ROUND ROUND( ,0) 123 ROUND( ,2) ROUND( , -2) 100 SECOND SIGN SIN SQRT TAN YEAR YEAR(DATE '2016/01/30') 2016 CURDATE CURRENT_DATE CURTIME CURRENT_TIME CURTIMESTAMP CURRENT_TIMESTAMP TIMESTAMPVAL TIMESTAMPVAL('2016/01/30 14:00:00') DATE TODAY 2016/11/21 DATE() DATEVAL DATEVAL(' ') DATE() SQL CURRENT_DATE

33 2 33 CASE WHEN CASE CASE {WHEN THEN...}[ELSE ] END SELECT " ", CASE " " WHEN 'Exports UK' THEN 'Exports UK Found' WHEN 'Home Furniture Suppliers' THEN 'Home Furniture Suppliers Found' ELSE 'Neither Exports UK nor Home Furniture Suppliers' END, " " FROM " " CASE WHEN CASE {WHEN THEN...}[ELSE ] END SELECT " ", " ", CASE WHEN " " > 3000 THEN 'Above 3000' WHEN " " < 1000 THEN 'Below 3000' ELSE 'Between 1000 and 3000' END, " " FROM " " COALESCE SELECT " ", COALESCE(" "," ") FROM NULLIF 2 2 SELECT " ", NULLIF(" ", -1) " " FROM " "

34 2 34 FileMaker FileMaker SQL FileMaker FileMaker FileMaker_Tables FileMaker_Fields 2 ODBC SQLTables JDBC DatabaseMetaData gettables ExecuteSQL FileMaker_Tables FileMaker_Tables FileMaker FileMaker_Tables 1 TableName - 1 TableId - ID 1 BaseTableName - 1 BaseFileName - FileMaker 1 ModCount - SELECT TableName FROM FileMaker_Tables WHERE TableName LIKE Sales% FileMaker_Fields FileMaker_Fields FileMaker FileMaker_Fields 1 TableName - 1 FieldName - 1 FieldType - SQL 1 FieldId - ID 1 FieldClass - 3 Summary ( )Calculated ( ) Normal 1 FieldReps - 1 ModCount - : SELECT * FROM FileMaker_Fields WHERE TableName= Sales

35 2 35 FileMaker FileMaker FileMaker ODBC SQLSpecialColumns JDBC DatabaseMetaData getversioncolumns ExecuteSQL ROWID ROWID ID ID FileMaker Pro Get ( ID ) ROWMODID ROWMODID FileMaker Pro Get ( ) : SELECT ROWID, ROWMODID FROM MyTable WHERE ROWMODID > 3

36 2 36 SQL CREATE TABLE DEC create table t ("dec" numeric) ABSOLUTE ACTION ADD ALL ALLOCATE ALTER AND ANY ARE AS ASC ASSERTION AT AUTHORIZATION AVG BEGIN BETWEEN BINARY BIT BIT_LENGTH BLOB BOOLEAN BOTH BY CASCADE CASCADED CASE CAST CATALOG CHAR CHARACTER CHARACTER_LENGTH CHAR_LENGTH CHECK CHR CLOSE COALESCE COLLATE COLLATION COLUMN COMMIT CONNECT CONNECTION CONSTRAINT CONSTRAINTS CONTINUE CONVERT CORRESPONDING COUNT CREATE CROSS CURDATE CURRENT CURRENT_DATE CURRENT_TIME CURRENT_TIMESTAMP CURRENT_USER CURSOR CURTIME CURTIMESTAMP DATE DATEVAL DAY DAYNAME DAYOFWEEK DEALLOCATE DEC DECIMAL DECLARE DEFAULT DEFERRABLE DEFERRED DELETE DESC DESCRIBE DESCRIPTOR DIAGNOSTICS DISCONNECT DISTINCT DOMAIN DOUBLE DROP ELSE END END_EXEC ESCAPE EVERY

37 2 37 EXCEPT EXCEPTION EXEC EXECUTE EXISTS EXTERNAL EXTRACT FALSE FETCH FIRST FLOAT FOR FOREIGN FOUND FROM FULL GET GLOBAL GO GOTO GRANT GROUP HAVING HOUR IDENTITY IMMEDIATE IN INDEX INDICATOR INITIALLY INNER INPUT INSENSITIVE INSERT INT INTEGER INTERSECT INTERVAL INTO IS ISOLATION JOIN KEY LANGUAGE LAST LEADING LEFT LENGTH LEVEL LIKE LOCAL LONGVARBINARY LOWER LTRIM MATCH MAX MIN MINUTE MODULE MONTH MONTHNAME NAMES NATIONAL NATURAL NCHAR NEXT NO NOT NULL NULLIF NUMERIC NUMVAL OCTET_LENGTH OF OFFSET ON ONLY OPEN OPTION OR ORDER OUTER OUTPUT OVERLAPS PAD PART PARTIAL PERCENT POSITION PRECISION PREPARE PRESERVE PRIMARY PRIOR PRIVILEGES PROCEDURE PUBLIC READ REAL REFERENCES RELATIVE RESTRICT REVOKE RIGHT ROLLBACK ROUND ROW ROWID ROWS RTRIM SCHEMA SCROLL SECOND SECTION SELECT SESSION SESSION_USER

38 2 38 SET SIZE SMALLINT SOME SPACE SQL SQLCODE SQLERROR SQLSTATE STRVAL SUBSTRING SUM SYSTEM_USER TABLE TEMPORARY THEN TIES TIME TIMESTAMP TIMESTAMPVAL TIMEVAL TIMEZONE_HOUR TIMEZONE_MINUTE TO TODAY TRAILING TRANSACTION TRANSLATE TRANSLATION TRIM TRUE TRUNCATE UNION UNIQUE UNKNOWN UPDATE UPPER USAGE USER USERNAME USING VALUE VALUES VARBINARY VARCHAR VARYING VIEW WHEN WHENEVER WHERE WITH WORK WRITE YEAR ZONE

39 A ABS 31 ALL 26 ALTER TABLE (SQL ) 22 AND 27 ANY 26 ATAN 31 ATAN2 31 B BaseFileName 34 BaseTableName 34 BETWEEN 26 BLOB SELECT 15 C CASE WHEN 33 CAST 16 CEIL 31 CEILING 31 CHR 30 COALESCE 33 CREATE INDEX (SQL ) 22 CREATE TABLE (SQL ) 20 CURDATE 32 CURRENT USER 30 CURRENT_DATE 32 CURRENT_TIME 32 CURRENT_TIMESTAMP 32 CURRENT_USER 30 CURTIME 32 CURTIMESTAMP 32 D DATE 32 DATEVAL 32 DAY 31 DAYNAME 30 DAYOFWEEK 31 DEFAULT (SQL ) 20 DEG 31 DEGREES 31 DELETE (SQL ) 17 DISTINCT 8 DROP INDEX (SQL ) 23 E ExecuteSQL 6, 7 EXISTS 26 EXP 31 EXTERNAL (SQL ) 21 F FETCH FIRST (SQL ) 13 FieldClass 34 FieldId 34 FieldName 34 FieldReps 34 FieldType 34 FileMaker Server 5 FileMaker_Fields 34 FileMaker_Tables 34 FLOOR 31 FOR UPDATE (SQL ) 14 FROM (SQL ) 9 FULL OUTER JOIN 10 G GetAs 16 GROUP BY (SQL ) 11 H HAVING (SQL ) 11 HOUR 31 I IN 26 INNER JOIN 10 INSERT (SQL ) 17 INT 32 IS NOT NULL 26 IS NULL 26 J JDBC Unicode 7 7 L LEFT OUTER JOIN 10 LEFT 30 LENGTH 32 LIKE 26 LN 32 LOG 32 LOWER 30 LTRIM 30

40 40 M MAX 32 MIN 32 MINUTE 32 MOD 31 ModCount 34 MONTH 32 MONTHNAME 30 N NOT IN 26 NOT LIKE 26 NOT NULL (SQL ) 20 NOT 27 NULLIF 33 NUMVAL 32 O ODBC Unicode 7 7 ODBC 14 ODBC 7 OFFSET (SQL ) 13 OR 27 ORDER BY (SQL ) 12 OUTER JOIN 10 P PDF 5 PI 32 PREVENT INDEX CREATION 23 PutAs 18, 19 R RADIANS 32 RIGHT OUTER JOIN 10 RIGHT 30 ROUND 32 ROWID 35 ROWMODID 35 RTRIM 30 S SECOND 32 SELECT (SQL ) 8 BLOB SIGN 32 SIN 32 SPACE 30 SQL SQL 28 SQL 25 SQL 28 SQL 25 SQL 25 SQL 24 SQL 25 SQL 23 SQL 25 SQL 26 SQL 27 SQL ALTER TABLE 22 CREATE INDEX 22 CREATE TABLE 20 DELETE 17 DROP INDEX 23 INSERT 17 SELECT 8 TRUNCATE TABLE 21 UPDATE SQL 28 SQL 23 SQL 7 SQL_C_WCHAR 7 SQL-92 7 SQRT 32 STRVAL 30 SUBSTR 30 SUBSTRING 30 T TableId 34 TableName 34 TAN 32 TIME 30 TIMESTAMPVAL 32 TIMEVAL 30 TODAY 32 TRIM 30 TRUNCATE TABLE (SQL ) 21

41 41 U Unicode 7 UNION (SQL ) 12 UNIQUE (SQL ) 20 UPDATE (SQL ) 19 UPPER 30 USERNAME 30 V VALUES (SQL ) 17 W WHERE (SQL ) 10 WITH TIES (SQL ) 13 Y YEAR CREATE TABLE 21 GetAs 16 INSERT 18 PutAs 18 SELECT 16 UPDATE SELECT 15 SQL , 9 18 SELECT 15 13, , SQL