Kexi/Handbook/References/SQL Reference/SQL Reserved Words

From KDE Wiki Sandbox
Revision as of 21:23, 27 August 2014 by Jstaniek (talk | contribs) (Created page with "<languages/> <translate> ==SQL Reserved Words== <!--T:20--> <!--T:1--> The following lists contain words that should not be used because '''Kexi''' can use them in actual or ...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

SQL Reserved Words

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.