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

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.

@@ Line 1,189: / Line 1,189: @@
 * VIEW
 {{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:Kexi]]