预留的 SQL 关键字

以下关键字不应用作列、表、别名或其他用户定义对象的名称。如果您收到语法错误，这些错误可能是由于使用了以下预留关键字之一导致的。如果要使用以下关键字之一，需要使用引号防止将其视为关键字。

示例

使用 DEC 关键字作为数据元素名称。

复制 
CREATE TABLE t ("dec" numeric)

  • ABSOLUTE

  • ACTION

  • ADD

  • ALL

  • ALLOCATE

  • ALTER

  • AND

  • ANY

  • ARE

  • AS

  • ASC

  • ASSERTION

  • AT

  • AUTHORIZATION

  • AVG

  • BEGIN

  • BETWEEN

  • BINARY

  • BIT

  • BIT_LENGTH

  • BLOB

  • BOOLEAN

  • BOTH

  • BY

  • CASCADE

  • CASCADED

  • CASE

  • CAST

  • CATALOG

  • CHAR

  • CHARACTER

  • CHARACTER_LENGTH

  • CHAR_LENGTH

  • CHECK

  • CHR

  • CLOSE

  • COALESCE

  • COLLATE

  • COLLATION

  • COLUMN

  • COMMIT

  • CONNECT

  • CONNECTION

  • CONSTRAINT

  • CONSTRAINTS

  • CONTINUE

  • CONVERT

  • CORRESPONDING

  • COUNT

  • CREATE

  • CROSS

  • CURDATE

  • CURRENT

  • CURRENT_DATE

  • CURRENT_TIME

  • CURRENT_TIMESTAMP

  • CURRENT_USER

  • CURSOR

  • CURTIME

  • CURTIMESTAMP

  • DATE

  • DATEVAL

  • DAY

  • DAYNAME

  • DAYOFWEEK

  • DEALLOCATE

  • DEC

  • DECIMAL

  • DECLARE

  • DEFAULT

  • DEFERRABLE

  • DEFERRED

  • DELETE

  • DESC

  • DESCRIBE

  • DESCRIPTOR

  • DIAGNOSTICS

  • DISCONNECT

  • DISTINCT

  • DOMAIN

  • DOUBLE

  • DROP

  • ELSE

  • END

  • END_EXEC

  • ESCAPE

  • EVERY

  • EXCEPT

  • EXCEPTION

  • EXEC

  • EXECUTE

  • EXISTS

  • EXTERNAL

  • EXTRACT

  • FALSE

  • FETCH

  • FIRST

  • FLOAT

  • FOR

  • FOREIGN

  • FOUND

  • FROM

  • FULL

  • GET

  • GLOBAL

  • GO

  • GOTO

  • GRANT

  • GROUP

  • HAVING

  • HOUR

  • IDENTITY

  • IMMEDIATE

  • IN

  • INDEX

  • INDICATOR

  • INITIALLY

  • INNER

  • INPUT

  • INSENSITIVE

  • INSERT

  • INT

  • INTEGER

  • INTERSECT

  • INTERVAL

  • INTO

  • IS

  • ISOLATION

  • JOIN

  • KEY

  • LANGUAGE

  • LAST

  • LEADING

  • LEFT

  • LENGTH

  • LEVEL

  • LIKE

  • LOCAL

  • LONGVARBINARY

  • LOWER

  • LTRIM

  • MATCH

  • MAX

  • MIN

  • MINUTE

  • MODULE

  • MONTH

  • MONTHNAME

  • NAMES

  • NATIONAL

  • NATURAL

  • NCHAR

  • NEXT

  • NO

  • NOT

  • NULL

  • NULLIF

  • NUMERIC

  • NUMVAL

  • OCTET_LENGTH

  • OF

  • OFFSET

  • ON

  • ONLY

  • OPEN

  • OPTION

  • OR

  • ORDER

  • OUTER

  • OUTPUT

  • OVERLAPS

  • PAD

  • PART

  • PARTIAL

  • PERCENT

  • POSITION

  • PRECISION

  • PREPARE

  • PRESERVE

  • PRIMARY

  • PRIOR

  • PRIVILEGES

  • PROCEDURE

  • PUBLIC

  • READ

  • REAL

  • REFERENCES

  • RELATIVE

  • RESTRICT

  • REVOKE

  • RIGHT

  • ROLLBACK

  • ROUND

  • ROW

  • ROWID

  • ROWS

  • RTRIM

  • SCHEMA

  • SCROLL

  • SECOND

  • SECTION

  • SELECT

  • SESSION

  • SESSION_USER

  • SET

  • SIZE

  • SMALLINT

  • SOME

  • SPACE

  • SQL

  • SQLCODE

  • SQLERROR

  • SQLSTATE

  • STRVAL

  • SUBSTRING

  • SUM

  • SYSTEM_USER

  • TABLE

  • TEMPORARY

  • THEN

  • TIES

  • TIME

  • TIMESTAMP

  • TIMESTAMPVAL

  • TIMEVAL

  • TIMEZONE_HOUR

  • TIMEZONE_MINUTE

  • TO

  • TODAY

  • TRAILING

  • TRANSACTION

  • TRANSLATE

  • TRANSLATION

  • TRIM

  • TRUE

  • TRUNCATE

  • UNION

  • UNIQUE

  • UNKNOWN

  • UPDATE

  • UPPER

  • USAGE

  • USER

  • USERNAME

  • USING

  • VALUE

  • VALUES

  • VARBINARY

  • VARCHAR

  • VARYING

  • VIEW

  • WHEN

  • WHENEVER

  • WHERE

  • WITH

  • WORK

  • WRITE

  • YEAR

  • ZONE