SQL ist eine Sprache, in der Schlüsselwörtern verwendet werden. Schlüsselwörter sind spezielle Wörter, die zum Ausführen von SQL-Operationen verwendet werden. Beim Benennen von Datenbanken, Tabellen, Spalten und anderen Datenbankobjekten, dürfen diese Schlüsselwörter nicht verwendet werden.
Bitte beachten Sie die folgenden Punkte.
1.Die Schlüsselwörter variieren je nach Datenbank. Nicht alle der aufgeführten Schlüsselwörter gelten für allen Datenbanken.
2.Einige Datenbanken haben reservierte SQL-Wörter um Begriffe erweitert, die speziell für deren Implementierung vorgesehen sind. Die meisten Datenbank spezifischen Schlüsselwörter sind unten nicht aufgeführt.
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
access
add
all
alter
analyze
and
any
as
asc
asensitive
audit
authorization
backup
before
begin
between
bigint
binary
blob
both
break
browse
bulk
by
call
cascade
case
change
char
character
check
checkpoint
close
cluster
clustered
coalesce
collate
column
columns
Commit
Comment
compress
compute
condition
connect
connection
contains
containstable
constraint
continue
convert
create
cross
current
current_date
current_time
current_timestamp
current_user
cursor
database
databases
date
day_hour
day_microsecond
day_minute
day_second
dbcc
deallocate
dec
decimal
declare
default
delayed
delete
deny
desc
describe
deterministic
disk
distinct
distinctrow
distributed
div
double
drop
dual
dump
each
else
elseif
enclosed
end
errlvl
escape
escaped
execute
exec
except
exists
exit
exclusive
explain
external
false
fetch
fields
file
fillfactor
float
float4
float8
for
force
foreign
freetext
freetexttable
from
full
function
fulltext
goto
grant
group
having
high_priority
holdlock
hour_microsecond
hour_minute
hour_second
identified
Identity
identity_insert
identitycol
if
ignore
immediate
in
increment
index
infile
initial
inner
inout
insensitive
insert
int
int1
int2
int3
int4
int8
integer
into
iterate
intersect
interval
is
Join
key
keys
kill
label
leading
leave
left
level
like
limit
lineno
lines
load
localtime
localtimestamp
lock
long
longblob
longtext
loop
low_priority
Match
maxextents
mediumblob
mediumint
mediumtext
middleint
minus
minute_microsecond
minute_second
mlslabel
mod
mode
modify
modifies
national
natural
nocheck
nonclustered
noaudit
nocompress
not
nowait
no_write_to_binlog
null
nullif
number
numeric
of
off
offline
offsets
on
online
open
opendatasource
openrowset
openquery
openxml
optimize
option
optionally
or
order
out
outer
outfile
over
Percent
Pctfree
Pivot
plan
precision
primary
privileges
procedure
prior
proc
public
purge
Raiserror
raw
read
reads
readtext
real
reconfigure
references
regexp
release
rename
repeat
replace
replication
require
resource
restore
restrict
return
revert
revoke
right
rlike
rollback
row
rowcount
rowid
rownum
rowguidcol
rows
rule
save
schema
schemas
second_microsecond
securityaudit
select
sensitive
separator
session
session_user
set
setuser
share
show
shutdown
size
smallint
some
soname
spatial
specific
sql
sqlexception
sqlstate
sqlwarning
sql_big_result
sql_calc_found_rows
sql_small_result
ssl
start
starting
statistics
straight_join
successful
synonym
sysdate
system_user
table
tables
tablesample
terminated
textsize
then
tinyblob
tinyint
tinytext
to
top
trailing
tran
transaction
truncate
tsequal
trigger
true
uid
undo
union
unique
unlock
unpivot
unsigned
update
updatetext
upgrade
usage
use
user
using
utc_date
utc_time
utc_timestamp
validate
values
varbinary
varchar
varchar2
varcharacter
varying
view
waitfor
when
whenever
where
while
with
write
writetext
Xor
year_month
Zerofill
