Mots-clés SQL réservés
Les mots-clés réservés suivants ne doivent pas être utilisés comme noms de colonnes, de tables, d'alias ou d'autres objets définis par l'utilisateur. Si vous obtenez des erreurs de syntaxe, ces erreurs peuvent être dues à l'utilisation de l'un de ces mots-clés réservés. Si vous souhaitez utiliser l'un d'entre eux, utilisez des guillemets pour éviter que le mot ne soit traité comme un mot-clé.
Utilisez le mot-clé DEC
comme nom d'élément de données.
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