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

From KDE UserBase Wiki
(Updating to match new version of source page)
(Updating to match new version of source page)
Line 1,189: Line 1,189:
* VIEW
* VIEW
{{Note|Reserved words are kept separate for each driver so that they can also be used as reference.}}
{{Note|Reserved words are kept separate for each driver so that they can also be used as reference.}}
{{Prevnext2
|prevpage=Special:MyLanguage/Kexi/Handbook/Comparing Kexi to other database applications/Data types
|prevtext=Data types
|index=Special:MyLanguage/Kexi/Handbook|indextext=Back to menu
}}


[[Category:Office]]
[[Category:Office]]
[[Category:Kexi]]
[[Category:Kexi]]

Revision as of 13:08, 20 October 2011

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

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.