/
Database reserved words

Database reserved words

By svitlana (Deactivated)
Jun 25, 2019


If you use one of the following words in your query specification, you will get a warning that this might collide with the underlying database

  • ACCESS
  • ADD
  • ALL
  • ALTER
  • ANALYZE
  • AND
  • ANY
  • ARRAYLEN
  • AS
  • ASC
  • ASENSITIVE
  • AUDIT
  • BEFORE
  • BETWEEN
  • BIGINT
  • BINARY
  • BLOB
  • BOTH
  • BY
  • CALL
  • CASCADE
  • CASE
  • CHANGE
  • CHAR
  • CHARACTER
  • CHECK
  • CLUSTER
  • COLLATE
  • COLUMN
  • COLUMNS
  • COMMENT
  • COMPRESS
  • CONDITION
  • CONNECT
  • CONNECTION
  • CONSTRAINT
  • CONTINUE
  • CONVERT
  • COUNT
  • CREATE CROSS
  • CREATE
  • CURRENT
  • CURRENT_DATE
  • CURRENT_TIME
  • CURRENT_TIMESTAMP
  • CURRENT_USER
  • CURSOR DATABASE
  • DATABASES
  • DATE
  • DAY_HOUR
  • DAY_MICROSECOND
  • DAY_MINUTE
  • DAY_SECOND
  • DEC
  • DECIMAL
  • DECLARE
  • DEFAULT
  • DELAYED
  • DELETE
  • DESC
  • DESCRIBE
  • DETERMINISTIC
  • DISTINCT
  • DISTINCTROW
  • DIV
  • DOUBLE
  • DROP
  • DUAL
  • EACH
  • ELSE
  • ELSEIF
  • EMPTY
  • ENCLOSED
  • ESCAPED
  • EXCLUSIVE
  • EXISTS
  • EXIT
  • EXPLAIN
  • FALSE
  • FETCH
  • FIELDS
  • FILE
  • FLOAT
  • FLOAT4
  • FLOAT8
  • FOR
  • FORCE
  • FOREIGN
  • FROM
  • FULLTEXT
  • GOTO
  • GRANT
  • GROUP
  • HAVING
  • HIGH_PRIORITY
  • HOUR_MICROSECOND
  • HOUR_MINUTE
  • HOUR_SECOND
  • IDENTIFIED
  • IF
  • IGNORE
  • IMMEDIATE
  • IN INDEX
  • IN
  • INCREMENT
  • INDEX
  • INFILE
  • INITIAL
  • INNER
  • INOUT
  • INSENSITIVE
  • INSERT
  • INT
  • INT1
  • INT2
  • INT3
  • INT4
  • INT8
  • INTEGER
  • INTERSECT
  • INTERVAL
  • INTO
  • IS
  • ITERATE
  • JOIN
  • KEY
  • KEYS
  • KILL
  • LABEL
  • LEADING
  • LEAVE
  • LEFT
  • LEVEL
  • LIKE
  • LIMIT
  • LINES
  • LOAD
  • LOCALTIME
  • LOCALTIMESTAMP
  • LOCK
  • LONG
  • LONGBLOB
  • LONGTEXT
  • LOOP
  • LOW_PRIORITY
  • MATCH
  • MAX
  • MAXEXTENTS
  • MEDIUMBLOB
  • MEDIUMINT
  • MEDIUMTEXT
  • MIDDLEINT
  • MIN
  • MINUS
  • MINUTE_MICROSECOND
  • MINUTE_SECOND
  • MOD
  • MODE
  • MODIFIES
  • MODIFY
  • NATURAL
  • NOAUDIT
  • NOCOMPRESS
  • NOT
  • NOTFOUND
  • NOWAIT
  • NO_WRITE_TO_BINLOG
  • NULL
  • NUMBER
  • NUMERIC
  • OF
  • OFFLINE
  • ON OPTIMIZE
  • ON
  • ONLINE
  • OPTION
  • OPTIONALLY
  • OR
  • ORDER
  • OUT
  • OUTER
  • OUTFILE
  • PCTFREE
  • PRECISION
  • PRIMARY
  • PRIOR
  • PRIVILEGES
  • PROCEDURE
  • PUBLIC
  • PURGE
  • RAW
  • READ
  • READS
  • REAL
  • REFERENCES
  • REGEXP
  • RELEASE
  • RENAME
  • REPEAT
  • REPLACE
  • REQUIRE
  • RESOURCE
  • RESOLUTION
  • RESTRICT
  • RETURN
  • REVOKE
  • RIGHT
  • RLIKE
  • ROW
  • ROWID
  • ROWLABEL
  • ROWNUM
  • ROWS
  • SCHEMA
  • SCHEMAS
  • SECOND_MICROSECOND
  • SELECT
  • SENSITIVE
  • SEPARATOR
  • SEQUENCE
  • SESSION
  • SET
  • SHARE
  • SHOW
  • SIZE
  • SMALLINT
  • SONAME
  • SPATIAL
  • SPECIFIC
  • SQL
  • SQLBUF
  • SQLEXCEPTION
  • SQLSTATE
  • SQLWARNING
  • SQL_BIG_RESULT
  • SQL_CALC_FOUND_ROWS
  • SQL_SMALL_RESULT
  • SSL
  • START
  • STARTING
  • STRAIGHT_JOIN
  • SUCCESSFUL
  • SYNONYM
  • SYSDATE
  • TABLE
  • TABLES
  • TERMINATED
  • THEN
  • TINYBLOB
  • TINYINT
  • TINYTEXT
  • TO
  • TRAILING
  • TRIGGER
  • TRUE
  • UID
  • UNDO
  • UNION
  • UNIQUE
  • UNLOCK
  • UNSIGNED
  • UPDATE
  • UPGRADE
  • USAGE
  • USE
  • USER
  • USING
  • UTC_DATE
  • UTC_TIME
  • UTC_TIMESTAMP
  • VALIDATE
  • VALUES
  • VARBINARY
  • VARCHAR
  • VARCHAR2
  • VARCHARACTER
  • VARYING
  • VIEW
  • WHENEVER
  • WHERE
  • WITH

Limitations

You can't use the following SQL operators in column naming:

SQL Arithmetic Operators

OperatorDescription
+Add
-Subtract
*Multiply
/Divide
%Modulo

SQL Bitwise Operators

OperatorDescription
&Bitwise AND
|Bitwise OR
^Bitwise exclusive OR

SQL Comparison Operators

OperatorDescription
=Equal to
>Greater than
<Less than
>=Greater than or equal to
<=Less than or equal to
<>Not equal to

SQL Compound Operators

OperatorDescription
+=Add equals
-=Subtract equals
*=Multiply equals
/=Divide equals
%=Modulo equals
&=Bitwise AND equals
^-=Bitwise exclusive equals
|*=Bitwise OR equals

Related content