Schlüsselwort (SQL): Unterschied zwischen den Versionen

Aus Byte-Welt Wiki
Zur Navigation springenZur Suche springen
(Kategorie geändert)
K
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==
Zeile 137: Zeile 137:
  
 
==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]]

Version vom 2. April 2018, 15:38 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.

Inhaltsverzeichnis 0-9 A B C D E F G H I J K L M N O P Q R S T U V W X Y Z



A

B

C

D

E

F

G

H

I

J

  • [[JOIN (SQL) | JOIN)

K

L

M

N

O

P

Q

R

S

T

U

V

W

X

Y

Z