예약 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