Schlüsselwort (SQL): Unterschied zwischen den Versionen
Aus Byte-Welt Wiki
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.
- 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
- DATE
- DAY
- DEALLOCATE
- DEC
- DECIMAL
- DECLARE
- DEFAULT
- DEFERRABLE
- DEFERRED
- DELETE
- DESC
- DESCRIBE
- DESCRIPTOR
- DIAGNOSTICS
- DISCONNECT
- DISTINCT
- DOMAIN
- DOUBLE
- DROP
- IDENTITY
- IMMEDIATE
- IN
- INDICATOR
- INITIALLY
- INNER
- INPUT
- INSENSITIVE
- INSERT
- INT
- INTEGER
- INTERSECT
- INTERVAL
- INTO
- IS
- ISOLATION
- SCHEMA
- SCROLL
- SECOND
- SECTION
- SELECT
- SESSION
- SESSION_USER
- SET
- SIZE
- SMALLINT
- SOME
- SQL
- SQLCODE
- SQLERROR
- SQLSTATE
- SUBSTRING
- SUM
- SYSTEM_USER
