Schlüsselwort (SQL): Unterschied zwischen den Versionen
Aus Byte-Welt Wiki
Zur Navigation springenZur Suche springenK (1 Versionen) |
(Kategorie geändert) |
||
Zeile 276: | Zeile 276: | ||
*ZONE | *ZONE | ||
− | [[Kategorie: | + | [[Kategorie:SQL]] |
Version vom 14. Juli 2007, 09:01 Uhr
Nach den ANSI Standards gibt es bei der Structured Query Language verschiedene Schlüsselworte, welche jedoch durch die Datenbankhersteller teilweise auch erweitert oder nicht eingehalten werden.
A
- ABSOLUTE
- ACTION
- ADD
- ALL
- ALLOCATE
- ALTER
- AND
- ANY
- ARE
- AS
- ASC
B
- BEGIN
- BETWEEN
- BIT
- BIT_LENGTH
- BOTH
- BY
C
- CASCADE
- CASCADED
- CASE
- CAST
- CATALOG
- CHAR
- CAHRACTER
- CHAR_LENGTH
- CHARACTER_LENGTH
- CHECK
- CLOSE
- COALESCE
- COLLATE
- COLLATION
- COLUMN
- COMMIT
- CONNECT
- CONNECTION
- CONSTRAINT
- CONSTRAINTS
- CONTINUE
- CONVERT
- CORRESPONDING
- COUNT
- CREATE
- CROSS
- CURRENT
- CURRENT_DATE
- CURRENT_TIME
- CURRENT_TIMESTAMP
- CURRENT_USER
- CURSOR
D
- DATE
- DAY
- DEALLOCATE
- DEC
- DECIMAL
- DECLARE
- DEFAULT
- DEFERRABLE
- DEFERRED
- DELETE
- DESC
- DESCRIBE
- DESCRIPTOR
- DIAGNOSTICS
- DISCONNECT
- DISTINCT
- DOMAIN
- DOUBLE
- DROP
E
- ELSE
- END
- END-EXEC
- ESCAPE
- EXCEPT
- EXCEPTION
- EXEC
- EXECUTE
- EXISTS
- EXTERNAL
- EXTRACT
F
- FALSE
- FECTCH
- FIRST
- FLOAT
- FOR
- FOREIGN
- FOUND
- FROM
- FULL
G
- GET
- GLOBAL
- GO
- GOTO
- GRAND
- GROUP
H
- HAVING
- HOUR
I
- IDENTITY
- IMMEDIATE
- IN
- INDICATOR
- INITIALLY
- INNER
- INPUT
- INSENSITIVE
- INSERT
- INT
- INTEGER
- INTERSECT
- INTERVAL
- INTO
- IS
- ISOLATION
J
- [[JOIN (SQL) | JOIN)
K
- KEY
L
- LANGUAGE
- LAST
- LEADING
- LEFT
- LEVEL
- LIKE
- LOCALE
- LOWER
M
- MATCH
- MAX
- MIN
- MINUTE
- MODULE
- MONTH
N
- NAMES
- NATIONAL
- NATURAL
- NCHAR
- NEXT
- NO
- NOT
- NULL
- NULLIF
- NUMERIC
O
- OCTET_LENGTH
- OF
- ON
- ONLY
- OPEN
- OPTION
- OR
- ORDER
- OUTHER
- OUTPUT
- OVERLAPS
P
- PARTIAL
- POSITION
- PRECISION
- PREPARE
- PRESERVE
- PRIMARY
- PRIOR
- PRIVILEGES
- PROCEDURE
- PUBLIC
Q
R
- READ
- REAL
- REFERENCES
- RELATIVE
- RESTRICT
- REVOKE
- RIGHT
- ROLLBAK
- ROWS
S
- SCHEMA
- SCROLL
- SECOND
- SECTION
- SELECT
- SESSION
- SESSION_USER
- SET
- SIZE
- SMALLINT
- SOME
- SQL
- SQLCODE
- SQLERROR
- SQLSTATE
- SUBSTRING
- SUM
- SYSTEM_USER
T
- TABLE
- TEMPORARY
- THEN
- TIME
- TIMESTAMP
- TIMEZONE_HOUR
- TIMEZONE_MINUTE
- TO
- TRAILING
- TRANSACTION
- TRANSLATE
- TRANSLATION
- TRIM
- TRUE
U
- UNION
- UNIQUE
- UNKNOWN
- UPDATE
- UPPER
- USAGE
- USER
- USING
V
- VALUE
- VALUES
- VARCHAR
- VARYING
- VIEW
W
- WHEN
- WHENEVER
- WHERE
- WITH
- WORK
- WRITE
X
Y
- YEAR
Z
- ZONE