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

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.

@@ Line 2: / Line 2: @@
 ==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 "".}}