Kexi/Handbook/References/SQL Reference/SQL Reserved Words: Difference between revisions

    From KDE UserBase Wiki
    (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 ...")
     
    (No difference)

    Latest revision as of 21:23, 27 August 2014

    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.