Schlüsselwort (SQL): Unterschied zwischen den Versionen

Aus Byte-Welt Wiki
Zur Navigation springenZur Suche springen
K (1 Versionen)
(Kategorie geändert)
Zeile 276: Zeile 276:
 
*ZONE
 
*ZONE
  
[[Kategorie:Datenbanken]]
+
[[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.

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

  • 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