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 2: Line 2:
==Reserved words for SQL==
==Reserved words for SQL==


The following lists contain words that are used internally by '''Kexi''' when dealing with data sources.
The following lists contain words that should not be used because '''Kexi''' can use them in actual or future versions when dealing with data. Note that this is not a list of SQL keywords that are supported by Kexi but reservation for the future.


{{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.}}
{{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 accidentally modify or remove the data.}}


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

Revision as of 08:14, 20 February 2014

Reserved words for SQL

The following lists contain words that should not be used because Kexi can use them in actual or future versions when dealing with data. Note that this is not a list of SQL keywords that are supported by Kexi but reservation for the future.

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 accidentally modify or remove the data.


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.