Kexi/Handbook/Appendix C. Reserved words for SQL/uk
Зарезервовані слова SQL
Нижче наведено список слів, які не слід використовувати, оскільки їх може бути використано у поточній або наступних версіях Kexi для обробки даних. Зауважте, що цей список не є списком усіх ключових слів SQL, підтримку яких передбачено у Kexi, а є лише списком слів, зарезервованих на майбутнє.
Зарезервовані слова Kexi для SQL
У цьому списку містяться ключові слова, які зарезервовано для використання додатком SQL до Kexi:
- 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
У цьому списку містяться ключові слова, які зарезервовано для використання додатком SQLite до Kexi:
- 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
У цьому списку містяться ключові слова, які зарезервовано для використання додатком MySQL до Kexi:
- 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
У цьому списку містяться ключові слова, які зарезервовано для використання драйвером pqxx Kexi:
- 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
У цьому списку містяться ключові слова, які зарезервовано для використання драйвером Oracle Kexi:
- 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
У цьому списку містяться ключові слова, які зарезервовано для використання драйвером Sybase Kexi:
- 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
У цьому списку містяться ключові слова, які зарезервовано для використання драйвером xBase Kexi:
- 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