View source for Kexi/Handbook/References/SQL Reference/SQL Reserved Words

<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 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.

<!--T:2-->
{{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.}}

<!--T:3-->
{{Tip|If you still want to use reserved words enclose them with double quotation marks "".}}

=== Kexi SQL Reserved words === <!--T:4-->

<!--T:5-->
This list contains keywords that are reserved for use in Kexi SQL:

</translate>
* 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
<translate>
=== Kexi SQLite Driver Reserved words === <!--T:6-->

<!--T:7-->
This list contains keywords that are reserved for use by Kexi SQLite Driver:

</translate>
* 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
<translate>
=== Kexi MySQL Driver Reserved words === <!--T:8-->

<!--T:9-->
This list contains keywords that are reserved for use by Kexi MySQL Driver:
</translate>

* 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
<translate>
=== Kexi PostgreSQL Driver Reserved words === <!--T:10-->

<!--T:11-->
This list contains keywords that are reserved for use by Kexi pqxx Driver:
</translate>
* 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
<translate>
=== Kexi Oracle Driver Reserved words === <!--T:12-->

<!--T:13-->
This list contains keywords that are reserved for use by Kexi Oracle Driver:
</translate>
* 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
<translate>

=== Kexi Sybase Driver Reserved words === <!--T:14-->

<!--T:15-->
This list contains keywords that are reserved for use by Kexi Sybase Driver:
</translate>
* 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
<translate>
=== Kexi xBase Driver Reserved words === <!--T:16-->

<!--T:17-->
This list contains keywords that are reserved for use by Kexi xBase Driver:
</translate>
* 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
<translate>
<!--T:18-->
{{Note|Reserved words are kept separate for each driver so that they can also be used as reference.}}

<!--T:19-->
[[Category:Office]]
[[Category:Kexi]]
</translate>