Kexi/Handbook/Appendix C. Reserved words for SQL/en: Difference between revisions

From KDE Wiki Sandbox
< Kexi‎ | Handbook
(Updating to match new version of source page)
(Updating to match new version of source page)
Line 662: Line 662:
This list contains keywords that are reserved for use by Kexi Oracle Driver:
This list contains keywords that are reserved for use by Kexi Oracle Driver:
* ADMIN
* ADMIN
* AFTER
* ALLOCATE
* ANALYZE
* ARCHIVE
* ARCHIVELOG
* AUTHORIZATION
* AVG
* BACKUP
* BECOME
* BEFORE
* BEGIN
* BLOCK
* BODY
* CACHE
* CANCEL
* CASCADE
* CHANGE
* CHARACTER
* CHECKPOINT
* CLOSE
* COBOL
* COMMIT
* COMPILE
* CONSTRAINT
* CONSTRAINTS
* CONTENTS
* CONTINUE
* CONTROLFILE
* COUNT
* CURSOR
* CURSOR
* CYCLE
* DATABASE
* DATAFILE
* DATE
* DATE
* DBA
* DEC
* DECLARE
* DISABLE
* DISMOUNT
* DOUBLE
* DUMP
* EACH
* ENABLE
* END
* ESCAPE
* EVENTS
* EXCEPT
* EXCEPTIONS
* EXEC
* EXECUTE
* EXPLAIN
* EXTENT
* EXTERNALLY
* FETCH
* FLUSH
* FORCE
* FOREIGN
* FORTRAN
* FOUND
* FOUND
* MOUNT
* FREELIST
* AFTER
* FREELISTS
* CYCLE
* FUNCTION
* FUNCTION
* NEXT
* ALLOCATE
* DATABASE
* GO
* GO
* GOTO
* GROUPS
* INCLUDING
* INDICATOR
* INITRANS
* INSTANCE
* INT
* KEY
* LANGUAGE
* LAYER
* LINK
* LISTS
* LOGFILE
* MANAGE
* MANUAL
* MAX
* MAXDATAFILES
* MAXINSTANCES
* MAXLOGFILES
* MAXLOGHISTORY
* MAXLOGMEMBERS
* MAXTRANS
* MAXVALUE
* MIN
* MINEXTENTS
* MINVALUE
* MODULE
* MOUNT
* NEW
* NEW
* ANALYZE
* NEXT
* DATAFILE
* GOTO
* NOARCHIVELOG
* NOARCHIVELOG
* ARCHIVE
* DBA
* GROUPS
* NOCACHE
* NOCACHE
* ARCHIVELOG
* DEC
* INCLUDING
* NOCYCLE
* NOCYCLE
* AUTHORIZATION
* DECLARE
* INDICATOR
* NOMAXVALUE
* NOMAXVALUE
* AVG
* DISABLE
* INITRANS
* NOMINVALUE
* NOMINVALUE
* BACKUP
* DISMOUNT
* INSTANCE
* NONE
* NONE
* BEGIN
* DOUBLE
* INT
* NOORDER
* NOORDER
* BECOME
* DUMP
* KEY
* NORESETLOGS
* NORESETLOGS
* BEFORE
* EACH
* LANGUAGE
* NORMAL
* NORMAL
* BLOCK
* ENABLE
* LAYER
* NOSORT
* NOSORT
* BODY
* END
* LINK
* NUMERIC
* NUMERIC
* CACHE
* ESCAPE
* LISTS
* OFF
* OFF
* CANCEL
* EVENTS
* LOGFILE
* OLD
* OLD
* CASCADE
* EXCEPT
* MANAGE
* ONLY
* ONLY
* CHANGE
* EXCEPTIONS
* MANUAL
* OPEN
* OPEN
* CHARACTER
* EXEC
* MAX
* OPTIMAL
* OPTIMAL
* CHECKPOINT
* EXPLAIN
* MAXDATAFILES
* OWN
* OWN
* CLOSE
* EXECUTE
* MAXINSTANCES
* PACKAGE
* PACKAGE
* COBOL
* EXTENT
* MAXLOGFILES
* PARALLEL
* PARALLEL
* COMMIT
* EXTERNALLY
* MAXLOGHISTORY
* PCTINCREASE
* PCTINCREASE
* COMPILE
* FETCH
* MAXLOGMEMBERS
* PCTUSED
* PCTUSED
* CONSTRAINT
* FLUSH
* MAXTRANS
* PLAN
* PLAN
* CONSTRAINTS
* FREELIST
* MAXVALUE
* PLI
* PLI
* CONTENTS
* FREELISTS
* MIN
* PRECISION
* PRECISION
* CONTINUE
* FORCE
* MINEXTENTS
* PRIMARY
* PRIMARY
* CONTROLFILE
* FOREIGN
* MINVALUE
* PRIVATE
* PRIVATE
* COUNT
* FORTRAN
* MODULE
* PROCEDURE
* PROCEDURE
* PROFILE
* PROFILE
* QUOTA
* READ
* REAL
* RECOVER
* REFERENCES
* REFERENCING
* RESETLOGS
* RESTRICTED
* REUSE
* ROLE
* ROLES
* ROLLBACK
* SAVEPOINT
* SAVEPOINT
* SCHEMA
* SCN
* SECTION
* SEGMENT
* SEQUENCE
* SHARED
* SNAPSHOT
* SOME
* SORT
* SQL
* SQLCODE
* SQLERROR
* SQLSTATE
* SQLSTATE
* TRACING
* QUOTA
* SCHEMA
* STATEMENT_ID
* STATEMENT_ID
* TRANSACTION
* READ
* SCN
* STATISTICS
* STATISTICS
* TRIGGERS
* REAL
* SECTION
* STOP
* STOP
* TRUNCATE
* RECOVER
* SEGMENT
* STORAGE
* STORAGE
* UNDER
* REFERENCES
* SEQUENCE
* SUM
* SUM
* UNLIMITED
* REFERENCING
* SHARED
* SWITCH
* SWITCH
* UNTIL
* RESETLOGS
* SNAPSHOT
* SYSTEM
* SYSTEM
* USE
* RESTRICTED
* SOME
* TABLES
* TABLES
* USING
* REUSE
* SORT
* TABLESPACE
* TABLESPACE
* WHEN
* ROLE
* SQL
* TEMPORARY
* TEMPORARY
* WRITE
* ROLES
* SQLCODE
* THREAD
* THREAD
* TIME
* TRACING
* TRANSACTION
* TRIGGERS
* TRUNCATE
* UNDER
* UNLIMITED
* UNTIL
* USE
* USING
* WHEN
* WORK
* WORK
* ROLLBACK
* WRITE
* SQLERROR
 
* TIME
=== Kexi Sybase Driver Reserved words ===
=== Kexi Sybase Driver Reserved words ===



Revision as of 16:57, 7 April 2012

Reserved words for SQL

The following lists contain words that are used internally by Kexi when dealing with data sources.

Warning
When designing your database you should do your best to avoid using these reserved words because otherwise you might end up having problems with your database file or even corrupt it.


Tip
If you still want to use reserved words enclose them with double quotation marks "".


Kexi SQL Reserved words

This list contains keywords that are reserved for use in Kexi SQL:

  • AFTER
  • ALL
  • ASC
  • BEFORE
  • BEGIN
  • BETWEEN
  • BY
  • CASCADE
  • CASE
  • CHECK
  • COLLATE
  • COMMIT
  • CONSTRAINT
  • CROSS
  • DATABASE
  • DEFAULT
  • DELETE
  • DESC
  • DISTINCT
  • DROP
  • END
  • ELSE
  • EXPLAIN
  • FOR
  • FOREIGN
  • FULL
  • GROUP
  • HAVING
  • IGNORE
  • INDEX
  • INNER
  • INSERT
  • INTO
  • KEY
  • LIMIT
  • MATCH
  • NATURAL
  • OFFSET
  • ORDER
  • OUTER
  • PRIMARY
  • REFERENCES
  • REPLACE
  • RESTRICT
  • ROLLBACK
  • ROW
  • SET
  • TEMPORARY
  • THEN
  • TRANSACTION
  • UNION
  • UNIQUE
  • UPDATE
  • USING
  • VALUES
  • WHEN

Kexi SQLite Driver Reserved words

This list contains keywords that are reserved for use by Kexi SQLite Driver:

  • ABORT
  • ATTACH
  • CLUSTER
  • CONFLICT
  • DEFERRED
  • DEFERRABLE
  • DETACH
  • EACH
  • EXCEPT
  • FAIL
  • GLOB
  • IMMEDIATE
  • INITIALLY
  • INSTEAD
  • INTERSECT
  • ISNULL
  • NOTNULL
  • OF
  • PRAGMA
  • RAISE
  • STATEMENT
  • TEMP
  • TRIGGER
  • VACUUM
  • VIEW

Kexi MySQL Driver Reserved words

This list contains keywords that are reserved for use by Kexi MySQL Driver:

  • ACTION
  • ADD
  • AGAINST
  • AGGREGATE
  • ALTER
  • ANALYZE
  • ANY
  • ASCII
  • AUTO_INCREMENT
  • AVG
  • AVG_ROW_LENGTH
  • BACKUP
  • BDB
  • BERKELEYDB
  • BIGINT
  • BINARY
  • BINLOG
  • BIT
  • BLOB
  • BOOL
  • BOOLEAN
  • BOTH
  • BTREE
  • BYTE
  • CACHE
  • CHANGE
  • CHANGED
  • CHAR
  • CHARACTER
  • CHARSET
  • CHECKSUM
  • CIPHER
  • CLIENT
  • CLOSE
  • COLLATION
  • COLUMN
  • COLUMNS
  • COMMENT
  • COMMITTED
  • COMPRESSED
  • CONCURRENT
  • CONVERT
  • CUBE
  • CURRENT_DATE
  • CURRENT_TIME
  • CURRENT_TIMESTAMP
  • CURRENT_USER
  • DATA
  • DATABASES
  • DATE
  • DATETIME
  • DAY
  • DAY_HOUR
  • DAY_MICROSECOND
  • DAY_MINUTE
  • DAY_SECOND
  • DEALLOCATE
  • DEC
  • DECIMAL
  • DELAYED
  • DELAY_KEY_WRITE
  • DESCRIBE
  • DES_KEY_FILE
  • DIRECTORY
  • DISABLE
  • DISCARD
  • DISTINCTROW
  • DIV
  • DO
  • DOUBLE
  • DUAL
  • DUMPFILE
  • DUPLICATE
  • DYNAMIC
  • ENABLE
  • ENCLOSED
  • ENGINE
  • ENGINES
  • ENUM
  • ERRORS
  • ESCAPE
  • ESCAPED
  • EVENTS
  • EXECUTE
  • EXISTS
  • EXPANSION
  • EXTENDED
  • FALSE
  • FAST
  • FIELDS
  • FILE
  • FIRST
  • FIXED
  • FLOAT
  • FLOAT4
  • FLOAT8
  • FLUSH
  • FORCE
  • FULLTEXT
  • FUNCTION
  • GEOMETRY
  • GEOMETRYCOLLECTION
  • GET_FORMAT
  • GLOBAL
  • GRANT
  • GRANTS
  • HANDLER
  • HASH
  • HELP
  • HIGH_PRIORITY
  • HOSTS
  • HOUR
  • HOUR_MICROSECOND
  • HOUR_MINUTE
  • HOUR_SECOND
  • IDENTIFIED
  • IF
  • IMPORT
  • INDEXES
  • INFILE
  • INNOBASE
  • INNODB
  • INSERT_METHOD
  • INT
  • INT1
  • INT2
  • INT3
  • INT4
  • INT8
  • INTERVAL
  • IO_THREAD
  • ISOLATION
  • ISSUER
  • KEYS
  • KILL
  • LAST
  • LEADING
  • LEAVES
  • LEVEL
  • LINES
  • LINESTRING
  • LOAD
  • LOCAL
  • LOCALTIME
  • LOCALTIMESTAMP
  • LOCK
  • LOCKS
  • LOGS
  • LONG
  • LONGBLOB
  • LONGTEXT
  • LOW_PRIORITY
  • MASTER
  • MASTER_CONNECT_RETRY
  • MASTER_HOST
  • MASTER_LOG_FILE
  • MASTER_LOG_POS
  • MASTER_PASSWORD
  • MASTER_PORT
  • MASTER_SERVER_ID
  • MASTER_SSL
  • MASTER_SSL_CA
  • MASTER_SSL_CAPATH
  • MASTER_SSL_CERT
  • MASTER_SSL_CIPHER
  • MASTER_SSL_KEY
  • MASTER_USER
  • MAX_CONNECTIONS_PER_HOUR
  • MAX_QUERIES_PER_HOUR
  • MAX_ROWS
  • MAX_UPDATES_PER_HOUR
  • MEDIUM
  • MEDIUMBLOB
  • MEDIUMINT
  • MEDIUMTEXT
  • MICROSECOND
  • MIDDLEINT
  • MINUTE
  • MINUTE_MICROSECOND
  • MINUTE_SECOND
  • MIN_ROWS
  • MOD
  • MODE
  • MODIFY
  • MONTH
  • MULTILINESTRING
  • MULTIPOINT
  • MULTIPOLYGON
  • NAMES
  • NATIONAL
  • NDB
  • NDBCLUSTER
  • NCHAR
  • NEW
  • NEXT
  • NO
  • NONE
  • NO_WRITE_TO_BINLOG
  • NUMERIC
  • NVARCHAR
  • OLD_PASSWORD
  • ONE_SHOT
  • OPEN
  • OPTIMIZE
  • OPTION
  • OPTIONALLY
  • OUTFILE
  • PACK_KEYS
  • PARTIAL
  • PASSWORD
  • POINT
  • POLYGON
  • PRECISION
  • PREPARE
  • PREV
  • PRIVILEGES
  • PROCEDURE
  • PROCESS
  • PROCESSLIST
  • PURGE
  • QUERY
  • QUICK
  • RAID0
  • RAID_CHUNKS
  • RAID_CHUNKSIZE
  • RAID_TYPE
  • READ
  • REAL
  • REGEXP
  • RELAY_LOG_FILE
  • RELAY_LOG_POS
  • RELAY_THREAD
  • RELOAD
  • RENAME
  • REPAIR
  • REPEATABLE
  • REPLICATION
  • REQUIRE
  • RESET
  • RESTORE
  • RETURNS
  • REVOKE
  • RLIKE
  • ROLLUP
  • ROWS
  • ROW_FORMAT
  • RTREE
  • SAVEPOINT
  • SECOND
  • SECOND_MICROSECOND
  • SEPARATOR
  • SERIAL
  • SERIALIZABLE
  • SESSION
  • SHARE
  • SHOW
  • SHUTDOWN
  • SIGNED
  • SIMPLE
  • SLAVE
  • SMALLINT
  • SOME
  • SONAME
  • SOUNDS
  • SPATIAL
  • SQL_BIG_RESULT
  • SQL_BUFFER_RESULT
  • SQL_CACHE
  • SQL_CALC_FOUND_ROWS
  • SQL_NO_CACHE
  • SQL_SMALL_RESULT
  • SQL_THREAD
  • SSL
  • START
  • STARTING
  • STATUS
  • STOP
  • STORAGE
  • STRAIGHT_JOIN
  • STRING
  • STRIPED
  • SUBJECT
  • SUPER
  • TABLES
  • TABLESPACE
  • TERMINATED
  • TEXT
  • TIME
  • TIMESTAMP
  • TINYBLOB
  • TINYINT
  • TINYTEXT
  • TRAILING
  • TRUE
  • TRUNCATE
  • TYPE
  • TYPES
  • UNCOMMITTED
  • UNICODE
  • UNLOCK
  • UNSIGNED
  • UNTIL
  • USAGE
  • USE
  • USER
  • USER_RESOURCES
  • USE_FRM
  • UTC_DATE
  • UTC_TIME
  • UTC_TIMESTAMP
  • VALUE
  • VARBINARY
  • VARCHAR
  • VARCHARACTER
  • VARIABLES
  • VARYING
  • WARNINGS
  • WITH
  • WORK
  • WRITE
  • X509
  • YEAR
  • YEAR_MONTH
  • ZEROFILL

Kexi PostgreSQL Driver Reserved words

This list contains keywords that are reserved for use by Kexi pqxx Driver:

  • ABORT
  • ABSOLUTE
  • ACCESS
  • ACTION
  • ADD
  • AGGREGATE
  • ALTER
  • ANALYSE
  • ANALYZE
  • ANY
  • ARRAY
  • ASSERTION
  • ASSIGNMENT
  • AT
  • AUTHORIZATION
  • BACKWARD
  • BIGINT
  • BINARY
  • BIT
  • BOOLEAN
  • BOTH
  • CACHE
  • CALLED
  • CAST
  • CHAIN
  • CHAR
  • CHARACTER
  • CHARACTERISTICS
  • CHECKPOINT
  • CLASS
  • CLOSE
  • CLUSTER
  • COALESCE
  • COLUMN
  • COMMENT
  • COMMITTED
  • CONSTRAINTS
  • CONVERSION
  • CONVERT
  • COPY
  • CREATEDB
  • CREATEUSER
  • CURRENT_DATE
  • CURRENT_TIME
  • CURRENT_TIMESTAMP
  • CURRENT_USER
  • CURSOR
  • CYCLE
  • DAY
  • DEALLOCATE
  • DEC
  • DECIMAL
  • DECLARE
  • DEFAULTS
  • DEFERRABLE
  • DEFERRED
  • DEFINER
  • DELIMITER
  • DELIMITERS
  • DO
  • DOMAIN
  • DOUBLE
  • EACH
  • ENCODING
  • ENCRYPTED
  • ESCAPE
  • EXCEPT
  • EXCLUDING
  • EXCLUSIVE
  • EXECUTE
  • EXISTS
  • EXTERNAL
  • EXTRACT
  • FALSE
  • FETCH
  • FIRST
  • FLOAT
  • FORCE
  • FORWARD
  • FREEZE
  • FUNCTION
  • GLOBAL
  • GRANT
  • HANDLER
  • HOLD
  • HOUR
  • ILIKE
  • IMMEDIATE
  • IMMUTABLE
  • IMPLICIT
  • INCLUDING
  • INCREMENT
  • INHERITS
  • INITIALLY
  • INOUT
  • INPUT
  • INSENSITIVE
  • INSTEAD
  • INT
  • INTERSECT
  • INTERVAL
  • INVOKER
  • ISNULL
  • ISOLATION
  • LANCOMPILER
  • LANGUAGE
  • LAST
  • LEADING
  • LEVEL
  • LISTEN
  • LOAD
  • LOCAL
  • LOCALTIME
  • LOCALTIMESTAMP
  • LOCATION
  • LOCK
  • MAXVALUE
  • MINUTE
  • MINVALUE
  • MODE
  • MONTH
  • MOVE
  • NAMES
  • NATIONAL
  • NCHAR
  • NEW
  • NEXT
  • NO
  • NOCREATEDB
  • NOCREATEUSER
  • NONE
  • NOTHING
  • NOTIFY
  • NOTNULL
  • NULLIF
  • NUMERIC
  • OF
  • OFF
  • OIDS
  • OLD
  • ONLY
  • OPERATOR
  • OPTION
  • OUT
  • OVERLAPS
  • OVERLAY
  • OWNER
  • PARTIAL
  • PASSWORD
  • PATH
  • PENDANT
  • PLACING
  • POSITION
  • PRECISION
  • PREPARE
  • PRESERVE
  • PRIOR
  • PRIVILEGES
  • PROCEDURAL
  • PROCEDURE
  • READ
  • REAL
  • RECHECK
  • REINDEX
  • RELATIVE
  • RENAME
  • RESET
  • RESTART
  • RETURNS
  • REVOKE
  • ROWS
  • RULE
  • SCHEMA
  • SCROLL
  • SECOND
  • SECURITY
  • SEQUENCE
  • SERIALIZABLE
  • SESSION
  • SESSION_USER
  • SETOF
  • SHARE
  • SHOW
  • SIMPLE
  • SMALLINT
  • SOME
  • STABLE
  • START
  • STATEMENT
  • STATISTICS
  • STDIN
  • STDOUT
  • STORAGE
  • STRICT
  • SUBSTRING
  • SYSID
  • TEMP
  • TEMPLATE
  • TIME
  • TIMESTAMP
  • TOAST
  • TRAILING
  • TREAT
  • TRIGGER
  • TRIM
  • TRUE
  • TRUNCATE
  • TRUSTED
  • TYPE
  • UNENCRYPTED
  • UNKNOWN
  • UNLISTEN
  • UNTIL
  • USAGE
  • USER
  • VACUUM
  • VALID
  • VALIDATOR
  • VARCHAR
  • VARYING
  • VERBOSE
  • VERSION
  • VIEW
  • VOLATILE
  • WITH
  • WITHOUT
  • WORK
  • WRITE
  • YEAR
  • ZONE

Kexi Oracle Driver Reserved words

This list contains keywords that are reserved for use by Kexi Oracle Driver:

  • ADMIN
  • AFTER
  • ALLOCATE
  • ANALYZE
  • ARCHIVE
  • ARCHIVELOG
  • AUTHORIZATION
  • AVG
  • BACKUP
  • BECOME
  • BEFORE
  • BEGIN
  • BLOCK
  • BODY
  • CACHE
  • CANCEL
  • CASCADE
  • CHANGE
  • CHARACTER
  • CHECKPOINT
  • CLOSE
  • COBOL
  • COMMIT
  • COMPILE
  • CONSTRAINT
  • CONSTRAINTS
  • CONTENTS
  • CONTINUE
  • CONTROLFILE
  • COUNT
  • CURSOR
  • CYCLE
  • DATABASE
  • DATAFILE
  • DATE
  • DBA
  • DEC
  • DECLARE
  • DISABLE
  • DISMOUNT
  • DOUBLE
  • DUMP
  • EACH
  • ENABLE
  • END
  • ESCAPE
  • EVENTS
  • EXCEPT
  • EXCEPTIONS
  • EXEC
  • EXECUTE
  • EXPLAIN
  • EXTENT
  • EXTERNALLY
  • FETCH
  • FLUSH
  • FORCE
  • FOREIGN
  • FORTRAN
  • FOUND
  • FREELIST
  • FREELISTS
  • FUNCTION
  • GO
  • GOTO
  • GROUPS
  • INCLUDING
  • INDICATOR
  • INITRANS
  • INSTANCE
  • INT
  • KEY
  • LANGUAGE
  • LAYER
  • LINK
  • LISTS
  • LOGFILE
  • MANAGE
  • MANUAL
  • MAX
  • MAXDATAFILES
  • MAXINSTANCES
  • MAXLOGFILES
  • MAXLOGHISTORY
  • MAXLOGMEMBERS
  • MAXTRANS
  • MAXVALUE
  • MIN
  • MINEXTENTS
  • MINVALUE
  • MODULE
  • MOUNT
  • NEW
  • NEXT
  • NOARCHIVELOG
  • NOCACHE
  • NOCYCLE
  • NOMAXVALUE
  • NOMINVALUE
  • NONE
  • NOORDER
  • NORESETLOGS
  • NORMAL
  • NOSORT
  • NUMERIC
  • OFF
  • OLD
  • ONLY
  • OPEN
  • OPTIMAL
  • OWN
  • PACKAGE
  • PARALLEL
  • PCTINCREASE
  • PCTUSED
  • PLAN
  • PLI
  • PRECISION
  • PRIMARY
  • PRIVATE
  • PROCEDURE
  • PROFILE
  • QUOTA
  • READ
  • REAL
  • RECOVER
  • REFERENCES
  • REFERENCING
  • RESETLOGS
  • RESTRICTED
  • REUSE
  • ROLE
  • ROLES
  • ROLLBACK
  • SAVEPOINT
  • SCHEMA
  • SCN
  • SECTION
  • SEGMENT
  • SEQUENCE
  • SHARED
  • SNAPSHOT
  • SOME
  • SORT
  • SQL
  • SQLCODE
  • SQLERROR
  • SQLSTATE
  • STATEMENT_ID
  • STATISTICS
  • STOP
  • STORAGE
  • SUM
  • SWITCH
  • SYSTEM
  • TABLES
  • TABLESPACE
  • TEMPORARY
  • THREAD
  • TIME
  • TRACING
  • TRANSACTION
  • TRIGGERS
  • TRUNCATE
  • UNDER
  • UNLIMITED
  • UNTIL
  • USE
  • USING
  • WHEN
  • WORK
  • WRITE

Kexi Sybase Driver Reserved words

This list contains keywords that are reserved for use by Kexi Sybase Driver:

  • ACTION
  • ADD
  • AGAINST
  • AGGREGATE
  • ALTER
  • ANALYZE
  • ANY
  • ASCII
  • AUTOINCREMENT
  • AVG
  • AVG_ROW_LENGTH
  • BACKUP
  • BDB
  • BERKELEYDB
  • BIGINT
  • BINARY
  • BINLOG
  • BIT
  • BLOB
  • BOOL
  • BOOLEAN
  • BOTH
  • BTREE
  • BYTE
  • CACHE
  • CHANGE
  • CHANGED
  • CHAR
  • CHARACTER
  • CHARSET
  • CHECKSUM
  • CIPHER
  • CLIENT
  • CLOSE
  • COLLATION
  • COLUMN
  • COLUMNS
  • COMMENT
  • COMMITTED
  • COMPRESSED
  • CONCURRENT
  • CONVERT
  • CUBE
  • CURRENT_DATE
  • CURRENT_TIME
  • CURRENT_TIMESTAMP
  • CURRENT_USER
  • DATA
  • DATABASES
  • DATE
  • DATETIME
  • DAY
  • DAY_HOUR
  • DAY_MICROSECOND
  • DAY_MINUTE
  • DAY_SECOND
  • DEALLOCATE
  • DEC
  • DECIMAL
  • DELAYED
  • DELAY_KEY_WRITE
  • DESCRIBE
  • DES_KEY_FILE
  • DIRECTORY
  • DISABLE
  • DISCARD
  • DISTINCTROW
  • DIV
  • DO
  • DOUBLE
  • DUAL
  • DUMPFILE
  • DUPLICATE
  • DYNAMIC
  • ENABLE
  • ENCLOSED
  • ENGINE
  • ENGINES
  • ENUM
  • ERRORS
  • ESCAPE
  • ESCAPED
  • EVENTS
  • EXECUTE
  • EXISTS
  • EXPANSION
  • EXTENDED
  • FALSE
  • FAST
  • FIELDS
  • FILE
  • FIRST
  • FIXED
  • FLOAT
  • FLOAT4
  • FLOAT8
  • FLUSH
  • FORCE
  • FULLTEXT
  • FUNCTION
  • GEOMETRY
  • GEOMETRYCOLLECTION
  • GET_FORMAT
  • GLOBAL
  • GRANT
  • GRANTS
  • HANDLER
  • HASH
  • HELP
  • HIGH_PRIORITY
  • HOSTS
  • HOUR
  • HOUR_MICROSECOND
  • HOUR_MINUTE
  • HOUR_SECOND
  • IDENTIFIED
  • IF
  • IMPORT
  • INDEXES
  • INFILE
  • INNOBASE
  • INNODB
  • INSERT_METHOD
  • INT
  • INT1
  • INT2
  • INT3
  • INT4
  • INT8
  • INTERVAL
  • IO_THREAD
  • ISOLATION
  • ISSUER
  • KEYS
  • KILL
  • LAST
  • LEADING
  • LEAVES
  • LEVEL
  • LINES
  • LINESTRING
  • LOAD
  • LOCAL
  • LOCALTIME
  • LOCALTIMESTAMP
  • LOCK
  • LOCKS
  • LOGS
  • LONG
  • LONGBLOB
  • LONGTEXT
  • LOW_PRIORITY
  • MASTER
  • MASTER_CONNECT_RETRY
  • MASTER_HOST
  • MASTER_LOG_FILE
  • MASTER_LOG_POS
  • MASTER_PASSWORD
  • MASTER_PORT
  • MASTER_SERVER_ID
  • MASTER_SSL
  • MASTER_SSL_CA
  • MASTER_SSL_CAPATH
  • MASTER_SSL_CERT
  • MASTER_SSL_CIPHER
  • MASTER_SSL_KEY
  • MASTER_USER
  • MAX_CONNECTIONS_PER_HOUR
  • MAX_QUERIES_PER_HOUR
  • MAX_ROWS
  • MAX_UPDATES_PER_HOUR
  • MEDIUM
  • MEDIUMBLOB
  • MEDIUMINT
  • MEDIUMTEXT
  • MICROSECOND
  • MIDDLEINT
  • MINUTE
  • MINUTE_MICROSECOND
  • MINUTE_SECOND
  • MIN_ROWS
  • MOD
  • MODE
  • MODIFY
  • MONTH
  • MULTILINESTRING
  • MULTIPOINT
  • MULTIPOLYGON
  • NAMES
  • NATIONAL
  • NDB
  • NDBCLUSTER
  • NCHAR
  • NEW
  • NEXT
  • NO
  • NONE
  • NO_WRITE_TO_BINLOG
  • NUMERIC
  • NVARCHAR
  • OLD_PASSWORD
  • ONE_SHOT
  • OPEN
  • OPTIMIZE
  • OPTION
  • OPTIONALLY
  • OUTFILE
  • PACK_KEYS
  • PARTIAL
  • PASSWORD
  • POINT
  • POLYGON
  • PRECISION
  • PREPARE
  • PREV
  • PRIVILEGES
  • PROCEDURE
  • PROCESS
  • PROCESSLIST
  • PURGE
  • QUERY
  • QUICK
  • RAID0
  • RAID_CHUNKS
  • RAID_CHUNKSIZE
  • RAID_TYPE
  • READ
  • REAL
  • REGEXP
  • RELAY_LOG_FILE
  • RELAY_LOG_POS
  • RELAY_THREAD
  • RELOAD
  • RENAME
  • REPAIR
  • REPEATABLE
  • REPLICATION
  • REQUIRE
  • RESET
  • RESTORE
  • RETURNS
  • REVOKE
  • RLIKE
  • ROLLUP
  • ROWS
  • ROW_FORMAT
  • RTREE
  • SAVEPOINT
  • SECOND
  • SECOND_MICROSECOND
  • SEPARATOR
  • SERIAL
  • SERIALIZABLE
  • SESSION
  • SHARE
  • SHOW
  • SHUTDOWN
  • SIGNED
  • SIMPLE
  • SLAVE
  • SMALLINT
  • SOME
  • SONAME
  • SOUNDS
  • SPATIAL
  • SQL_BIG_RESULT
  • SQL_BUFFER_RESULT
  • SQL_CACHE
  • SQL_CALC_FOUND_ROWS
  • SQL_NO_CACHE
  • SQL_SMALL_RESULT
  • SQL_THREAD
  • SSL
  • START
  • STARTING
  • STATUS
  • STOP
  • STORAGE
  • STRAIGHT_JOIN
  • STRING
  • STRIPED
  • SUBJECT
  • SUPER
  • TABLES
  • TABLESPACE
  • TERMINATED
  • TEXT
  • TIME
  • TIMESTAMP
  • TINYBLOB
  • TINYINT
  • TINYTEXT
  • TRAILING
  • TRUE
  • TRUNCATE
  • TYPE
  • TYPES
  • UNCOMMITTED
  • UNICODE
  • UNLOCK
  • UNSIGNED
  • UNTIL
  • USAGE
  • USE
  • USER
  • USER_RESOURCES
  • USE_FRM
  • UTC_DATE
  • UTC_TIME
  • UTC_TIMESTAMP
  • VALUE
  • VARBINARY
  • VARCHAR
  • VARCHARACTER
  • VARIABLES
  • VARYING
  • WARNINGS
  • WITH
  • WORK
  • WRITE
  • X509
  • YEAR
  • YEAR_MONTH
  • ZEROFILL

Kexi xBase Driver Reserved words

This list contains keywords that are reserved for use by Kexi xBase Driver:

  • ABORT
  • ATTACH
  • CLUSTER
  • CONFLICT
  • DEFERRED
  • DEFERRABLE
  • DETACH
  • EACH
  • EXCEPT
  • FAIL
  • GLOB
  • IMMEDIATE
  • INITIALLY
  • INSTEAD
  • INTERSECT
  • ISNULL
  • NOTNULL
  • OF
  • PRAGMA
  • RAISE
  • STATEMENT
  • TEMP
  • TRIGGER
  • VACUUM
  • VIEW
Note
Reserved words are kept separate for each driver so that they can also be used as reference.