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