Kexi/Handbook/Appendix C. Reserved words for SQL/da: Difference between revisions
Appearance
No edit summary |
Updating to match new version of source page |
||
Line 1,189: | Line 1,189: | ||
* VIEW | * VIEW | ||
{{Note/da|Reserverede ord er holdt adskilt for hver driver, sådan al listerne også kan bruges som en reference.}} | {{Note/da|Reserverede ord er holdt adskilt for hver driver, sådan al listerne også kan bruges som en 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:Kontor/da]] | [[Category:Kontor/da]] | ||
[[Category:Kexi/da]] | [[Category:Kexi/da]] |
Revision as of 13:08, 20 October 2011
Reserverede ord for SQL
Den følgende liste indeholder ord, som bruges internt af Kexi til at håndtere datakilder.
Kexis reserverede ord til SQL
Denne liste indeholder nøgleord, som er reserveret til brug i Kexis 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
Reserverede ord til Kexis SQLite-driver
Denne liste indeholder nøgleord, som er reserverede til brug for Kexis 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
Reserverede ord til Kexis MySQL-driver
Denne liste indeholder nøgleord, som er reserverede til brug for Kexis 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
Reserverede ord til Kexis PostgreSQL-driver
Denne liste indeholder nøgleord, som er reserverede til brug for Kexis 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
Reserverede ord til Kexis Oracle-driver
Denne liste indeholder nøgleord, som er reserverede til brug for Kexis 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
Reserverede ord til Kexis Sybase-driver
Denne liste indeholder nøgleord, som er reserverede til brug for Kexis 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
Reserverede ord til Kexis xBase-driver
Denne liste indeholder nøgleord, som er reserverede til brug for Kexis 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