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