A SERVICE OF

logo

Open as PDF
next previous
44 FileMaker ODBC and JDBC Guide
JDBC Meta Data functions
The JDBC client driver supports the following Meta Data functions:
1 getColumns
1 getColumnPrivileges
1 getMetaData
1 getTypeInfo
1 getTables
1 getTableTypes
Reserved SQL keywords
The following table lists reserved keywords that should not be used as names for columns, tables, aliases,
or other user-defined objects. If you are getting syntax errors, these errors may be due to using one of these
reserved words. If you want to use one of these keywords, you need to use quotation marks to prevent the
word from being treated as a keyword.
For example, the following Create Table statement shows how to use the "OID" keyword as a data element name.
create table t ("oid" numeric)
Reserved keywords
EXEC
EXECUTE
EXISTS
EXTERNAL
EXTRACT
FALSE
FETCH
FIRST
FLOAT
FLOOR
FOR
FOREIGN
FOUND
FROM
FULL
GENERAL
GET
GLOBAL
GO
GOTO
GRANT
GROUP
HAVING
HOUR
IDENTIFY
BREADTH
BY
CALL
CASCADE
CASCADED
CASE
CAST
CATALOG
CHAR
CHARACTER
CHARACTER_LENGTH
CHAR_LENGTH
CHECK
CHR
CLOSE
COALESCE
COLLATE
COLLATION
COLUMN
COLUMNS
COMMIT
COMPLETION
CONCAT
CONNECT
CONNECTION
DECLARE
DEFAULT
DEFERRABLE
DEFERRED
DELETE
DEPTH
DESC
DESCRIBE
DESCRIPTOR
DIAGNOSTICS
DICTIONARY
DISCONNECT
DISTINCT
DOMAIN
DOUBLE
DROP
EACH
ELSE
ELSEIF
END
END_EXEC
EQUALS
ESCAPE
EXCEPT
EXCEPTION
CONSTRAINT
CONSTRAINTS
CONTINUE
CONVERT
CORRESPONDING
COUNT
CREATE
CROSS
CURDATE
CURRENT
CURRENT_DATE
CURRENT_TIME
CURRENT_TIMESTAMP
CURRENT_USER
CURSOR
CURTIME
CYCLE
DATA
DATE
DAY
DAYOFMONTH
DAYOFWEEK
DEALLOCATE
DEC
DECIMAL
ABSOLUTE
ACTION
ADD
AFTER
ALIAS
ALL
ALLOCATE
ALTER
AND
ANY
ARE
AS
ASC
ASSERTION
ASYNC
AT
AUTHORIZATION
AV G
BEFORE
BEGIN
BETWEEN
BIT
BIT_LENGTH
BOOLEAN
BOTH