List of SQL reserved words

Last updated on
September 20, 2016 - 12:51

The list below represents a combination of the following sources of SQL reserved words:

There are undoubtedly more sources that we should add to this list, but this makes a very good starting point.

Reserved Words

  1. A

  2. ABORT

  3. ABS

  4. ABSOLUTE

  5. ACCESS

  6. ACTION

  7. ADA

  8. ADD

  9. ADMIN

  10. AFTER

  11. AGGREGATE

  12. ALIAS

  13. ALL

  14. ALLOCATE

  15. ALSO

  16. ALTER

  17. ALWAYS

  18. ANALYSE

  19. ANALYZE

  20. AND

  21. ANY

  22. ARE

  23. ARRAY

  24. AS

  25. ASC

  26. ASENSITIVE

  27. ASSERTION

  28. ASSIGNMENT

  29. ASYMMETRIC

  30. AT

  31. ATOMIC

  32. ATTRIBUTE

  33. ATTRIBUTES

  34. AUDIT

  35. AUTHORIZATION

  36. AUTO_INCREMENT

  37. AVG

  38. AVG_ROW_LENGTH

  39. BACKUP

  40. BACKWARD

  41. BEFORE

  42. BEGIN

  43. BERNOULLI

  44. BETWEEN

  45. BIGINT

  46. BINARY

  47. BIT

  48. BIT_LENGTH

  49. BITVAR

  50. BLOB

  51. BOOL

  52. BOOLEAN

  53. BOTH

  54. BREADTH

  55. BREAK

  56. BROWSE

  57. BULK

  58. BY

  59. C

  60. CACHE

  61. CALL

  62. CALLED

  63. CARDINALITY

  64. CASCADE

  65. CASCADED

  66. CASE

  67. CAST

  68. CATALOG

  69. CATALOG_NAME

  70. CEIL

  71. CEILING

  72. CHAIN

  73. CHANGE

  74. CHAR

  75. CHAR_LENGTH

  76. CHARACTER

  77. CHARACTER_LENGTH

  78. CHARACTER_SET_CATALOG

  79. CHARACTER_SET_NAME

  80. CHARACTER_SET_SCHEMA

  81. CHARACTERISTICS

  82. CHARACTERS

  83. CHECK

  84. CHECKED

  85. CHECKPOINT

  86. CHECKSUM

  87. CLASS

  88. CLASS_ORIGIN

  89. CLOB

  90. CLOSE

  91. CLUSTER

  92. CLUSTERED

  93. COALESCE

  94. COBOL

  95. COLLATE

  96. COLLATION

  97. COLLATION_CATALOG

  98. COLLATION_NAME

  99. COLLATION_SCHEMA

  100. COLLECT

  101. COLUMN

  102. COLUMN_NAME

  103. COLUMNS

  104. COMMAND_FUNCTION

  105. COMMAND_FUNCTION_CODE

  106. COMMENT

  107. COMMIT

  108. COMMITTED

  109. COMPLETION

  110. COMPRESS

  111. COMPUTE

  112. CONDITION

  113. CONDITION_NUMBER

  114. CONNECT

  115. CONNECTION

  116. CONNECTION_NAME

  117. CONSTRAINT

  118. CONSTRAINT_CATALOG

  119. CONSTRAINT_NAME

  120. CONSTRAINT_SCHEMA

  121. CONSTRAINTS

  122. CONSTRUCTOR

  123. CONTAINS

  124. CONTAINSTABLE

  125. CONTINUE

  126. CONVERSION

  127. CONVERT

  128. COPY

  129. CORR

  130. CORRESPONDING

  131. COUNT

  132. COVAR_POP

  133. COVAR_SAMP

  134. CREATE

  135. CREATEDB

  136. CREATEROLE

  137. CREATEUSER

  138. CROSS

  139. CSV

  140. CUBE

  141. CUME_DIST

  142. CURRENT

  143. CURRENT_DATE

  144. CURRENT_DEFAULT_TRANSFORM_GROUP

  145. CURRENT_PATH

  146. CURRENT_ROLE

  147. CURRENT_TIME

  148. CURRENT_TIMESTAMP

  149. CURRENT_TRANSFORM_GROUP_FOR_TYPE

  150. CURRENT_USER

  151. CURSOR

  152. CURSOR_NAME

  153. CYCLE

  154. DATA

  155. DATABASE

  156. DATABASES

  157. DATE

  158. DATETIME

  159. DATETIME_INTERVAL_CODE

  160. DATETIME_INTERVAL_PRECISION

  161. DAY

  162. DAY_HOUR

  163. DAY_MICROSECOND

  164. DAY_MINUTE

  165. DAY_SECOND

  166. DAYOFMONTH

  167. DAYOFWEEK

  168. DAYOFYEAR

  169. DBCC

  170. DEALLOCATE

  171. DEC

  172. DECIMAL

  173. DECLARE

  174. DEFAULT

  175. DEFAULTS

  176. DEFERRABLE

  177. DEFERRED

  178. DEFINED

  179. DEFINER

  180. DEGREE

  181. DELAY_KEY_WRITE

  182. DELAYED

  183. DELETE

  184. DELIMITER

  185. DELIMITERS

  186. DENSE_RANK

  187. DENY

  188. DEPTH

  189. DEREF

  190. DERIVED

  191. DESC

  192. DESCRIBE

  193. DESCRIPTOR

  194. DESTROY

  195. DESTRUCTOR

  196. DETERMINISTIC

  197. DIAGNOSTICS

  198. DICTIONARY

  199. DISABLE

  200. DISCONNECT

  201. DISK

  202. DISPATCH

  203. DISTINCT

  204. DISTINCTROW

  205. DISTRIBUTED

  206. DIV

  207. DO

  208. DOMAIN

  209. DOUBLE

  210. DROP

  211. DUAL

  212. DUMMY

  213. DUMP

  214. DYNAMIC

  215. DYNAMIC_FUNCTION

  216. DYNAMIC_FUNCTION_CODE

  217. EACH

  218. ELEMENT

  219. ELSE

  220. ELSEIF

  221. ENABLE

  222. ENCLOSED

  223. ENCODING

  224. ENCRYPTED

  225. END

  226. END-EXEC

  227. ENUM

  228. EQUALS

  229. ERRLVL

  230. ESCAPE

  231. ESCAPED

  232. EVERY

  233. EXCEPT

  234. EXCEPTION

  235. EXCLUDE

  236. EXCLUDING

  237. EXCLUSIVE

  238. EXEC

  239. EXECUTE

  240. EXISTING

  241. EXISTS

  242. EXIT

  243. EXP

  244. EXPLAIN

  245. EXTERNAL

  246. EXTRACT

  247. FALSE

  248. FETCH

  249. FIELDS

  250. FILE

  251. FILLFACTOR

  252. FILTER

  253. FINAL

  254. FIRST

  255. FLOAT

  256. FLOAT4

  257. FLOAT8

  258. FLOOR

  259. FLUSH

  260. FOLLOWING

  261. FOR

  262. FORCE

  263. FOREIGN

  264. FORTRAN

  265. FORWARD

  266. FOUND

  267. FREE

  268. FREETEXT

  269. FREETEXTTABLE

  270. FREEZE

  271. FROM

  272. FULL

  273. FULLTEXT

  274. FUNCTION

  275. FUSION

  276. G

  277. GENERAL

  278. GENERATED

  279. GET

  280. GLOBAL

  281. GO

  282. GOTO

  283. GRANT

  284. GRANTED

  285. GRANTS

  286. GREATEST

  287. GROUP

  288. GROUPING

  289. HANDLER

  290. HAVING

  291. HEADER

  292. HEAP

  293. HIERARCHY

  294. HIGH_PRIORITY

  295. HOLD

  296. HOLDLOCK

  297. HOST

  298. HOSTS

  299. HOUR

  300. HOUR_MICROSECOND

  301. HOUR_MINUTE

  302. HOUR_SECOND

  303. IDENTIFIED

  304. IDENTITY

  305. IDENTITY_INSERT

  306. IDENTITYCOL

  307. IF

  308. IGNORE

  309. ILIKE

  310. IMMEDIATE

  311. IMMUTABLE

  312. IMPLEMENTATION

  313. IMPLICIT

  314. IN

  315. INCLUDE

  316. INCLUDING

  317. INCREMENT

  318. INDEX

  319. INDICATOR

  320. INFILE

  321. INFIX

  322. INHERIT

  323. INHERITS

  324. INITIAL

  325. INITIALIZE

  326. INITIALLY

  327. INNER

  328. INOUT

  329. INPUT

  330. INSENSITIVE

  331. INSERT

  332. INSERT_ID

  333. INSTANCE

  334. INSTANTIABLE

  335. INSTEAD

  336. INT

  337. INT1

  338. INT2

  339. INT3

  340. INT4

  341. INT8

  342. INTEGER

  343. INTERSECT

  344. INTERSECTION

  345. INTERVAL

  346. INTO

  347. INVOKER

  348. IS

  349. ISAM

  350. ISNULL

  351. ISOLATION

  352. ITERATE

  353. JOIN

  354. K

  355. KEY

  356. KEY_MEMBER

  357. KEY_TYPE

  358. KEYS

  359. KILL

  360. LANCOMPILER

  361. LANGUAGE

  362. LARGE

  363. LAST

  364. LAST_INSERT_ID

  365. LATERAL

  366. LEADING

  367. LEAST

  368. LEAVE

  369. LEFT

  370. LENGTH

  371. LESS

  372. LEVEL

  373. LIKE

  374. LIMIT

  375. LINENO

  376. LINES

  377. LISTEN

  378. LN

  379. LOAD

  380. LOCAL

  381. LOCALTIME

  382. LOCALTIMESTAMP

  383. LOCATION

  384. LOCATOR

  385. LOCK

  386. LOGIN

  387. LOGS

  388. LONG

  389. LONGBLOB

  390. LONGTEXT

  391. LOOP

  392. LOW_PRIORITY

  393. LOWER

  394. M

  395. MAP

  396. MATCH

  397. MATCHED

  398. MAX

  399. MAX_ROWS

  400. MAXEXTENTS

  401. MAXVALUE

  402. MEDIUMBLOB

  403. MEDIUMINT

  404. MEDIUMTEXT

  405. MEMBER

  406. MERGE

  407. MESSAGE_LENGTH

  408. MESSAGE_OCTET_LENGTH

  409. MESSAGE_TEXT

  410. METHOD

  411. MIDDLEINT

  412. MIN

  413. MIN_ROWS

  414. MINUS

  415. MINUTE

  416. MINUTE_MICROSECOND

  417. MINUTE_SECOND

  418. MINVALUE

  419. MLSLABEL

  420. MOD

  421. MODE

  422. MODIFIES

  423. MODIFY

  424. MODULE

  425. MONTH

  426. MONTHNAME

  427. MORE

  428. MOVE

  429. MULTISET

  430. MUMPS

  431. MYISAM

  432. NAME

  433. NAMES

  434. NATIONAL

  435. NATURAL

  436. NCHAR

  437. NCLOB

  438. NESTING

  439. NEW

  440. NEXT

  441. NO

  442. NO_WRITE_TO_BINLOG

  443. NOAUDIT

  444. NOCHECK

  445. NOCOMPRESS

  446. NOCREATEDB

  447. NOCREATEROLE

  448. NOCREATEUSER

  449. NOINHERIT

  450. NOLOGIN

  451. NONCLUSTERED

  452. NONE

  453. NORMALIZE

  454. NORMALIZED

  455. NOSUPERUSER

  456. NOT

  457. NOTHING

  458. NOTIFY

  459. NOTNULL

  460. NOWAIT

  461. NULL

  462. NULLABLE

  463. NULLIF

  464. NULLS

  465. NUMBER

  466. NUMERIC

  467. OBJECT

  468. OCTET_LENGTH

  469. OCTETS

  470. OF

  471. OFF

  472. OFFLINE

  473. OFFSET

  474. OFFSETS

  475. OIDS

  476. OLD

  477. ON

  478. ONLINE

  479. ONLY

  480. OPEN

  481. OPENDATASOURCE

  482. OPENQUERY

  483. OPENROWSET

  484. OPENXML

  485. OPERATION

  486. OPERATOR

  487. OPTIMIZE

  488. OPTION

  489. OPTIONALLY

  490. OPTIONS

  491. OR

  492. ORDER

  493. ORDERING

  494. ORDINALITY

  495. OTHERS

  496. OUT

  497. OUTER

  498. OUTFILE

  499. OUTPUT

  500. OVER

  501. OVERLAPS

  502. OVERLAY

  503. OVERRIDING

  504. OWNER

  505. PACK_KEYS

  506. PAD

  507. PARAMETER

  508. PARAMETER_MODE

  509. PARAMETER_NAME

  510. PARAMETER_ORDINAL_POSITION

  511. PARAMETER_SPECIFIC_CATALOG

  512. PARAMETER_SPECIFIC_NAME

  513. PARAMETER_SPECIFIC_SCHEMA

  514. PARAMETERS

  515. PARTIAL

  516. PARTITION

  517. PASCAL

  518. PASSWORD

  519. PATH

  520. PCTFREE

  521. PERCENT

  522. PERCENT_RANK

  523. PERCENTILE_CONT

  524. PERCENTILE_DISC

  525. PLACING

  526. PLAN

  527. PLI

  528. POSITION

  529. POSTFIX

  530. POWER

  531. PRECEDING

  532. PRECISION

  533. PREFIX

  534. PREORDER

  535. PREPARE

  536. PREPARED

  537. PRESERVE

  538. PRIMARY

  539. PRINT

  540. PRIOR

  541. PRIVILEGES

  542. PROC

  543. PROCEDURAL

  544. PROCEDURE

  545. PROCESS

  546. PROCESSLIST

  547. PUBLIC

  548. PURGE

  549. QUOTE

  550. RAID0

  551. RAISERROR

  552. RANGE

  553. RANK

  554. RAW

  555. READ

  556. READS

  557. READTEXT

  558. REAL

  559. RECHECK

  560. RECONFIGURE

  561. RECURSIVE

  562. REF

  563. REFERENCES

  564. REFERENCING

  565. REGEXP

  566. REGR_AVGX

  567. REGR_AVGY

  568. REGR_COUNT

  569. REGR_INTERCEPT

  570. REGR_R2

  571. REGR_SLOPE

  572. REGR_SXX

  573. REGR_SXY

  574. REGR_SYY

  575. REINDEX

  576. RELATIVE

  577. RELEASE

  578. RELOAD

  579. RENAME

  580. REPEAT

  581. REPEATABLE

  582. REPLACE

  583. REPLICATION

  584. REQUIRE

  585. RESET

  586. RESIGNAL

  587. RESOURCE

  588. RESTART

  589. RESTORE

  590. RESTRICT

  591. RESULT

  592. RETURN

  593. RETURNED_CARDINALITY

  594. RETURNED_LENGTH

  595. RETURNED_OCTET_LENGTH

  596. RETURNED_SQLSTATE

  597. RETURNS

  598. REVOKE

  599. RIGHT

  600. RLIKE

  601. ROLE

  602. ROLLBACK

  603. ROLLUP

  604. ROUTINE

  605. ROUTINE_CATALOG

  606. ROUTINE_NAME

  607. ROUTINE_SCHEMA

  608. ROW

  609. ROW_COUNT

  610. ROW_NUMBER

  611. ROWCOUNT

  612. ROWGUIDCOL

  613. ROWID

  614. ROWNUM

  615. ROWS

  616. RULE

  617. SAVE

  618. SAVEPOINT

  619. SCALE

  620. SCHEMA

  621. SCHEMA_NAME

  622. SCHEMAS

  623. SCOPE

  624. SCOPE_CATALOG

  625. SCOPE_NAME

  626. SCOPE_SCHEMA

  627. SCROLL

  628. SEARCH

  629. SECOND

  630. SECOND_MICROSECOND

  631. SECTION

  632. SECURITY

  633. SELECT

  634. SELF

  635. SENSITIVE

  636. SEPARATOR

  637. SEQUENCE

  638. SERIALIZABLE

  639. SERVER_NAME

  640. SESSION

  641. SESSION_USER

  642. SET

  643. SETOF

  644. SETS

  645. SETUSER

  646. SHARE

  647. SHOW

  648. SHUTDOWN

  649. SIGNAL

  650. SIMILAR

  651. SIMPLE

  652. SIZE

  653. SMALLINT

  654. SOME

  655. SONAME

  656. SOURCE

  657. SPACE

  658. SPATIAL

  659. SPECIFIC

  660. SPECIFIC_NAME

  661. SPECIFICTYPE

  662. SQL

  663. SQL_BIG_RESULT

  664. SQL_BIG_SELECTS

  665. SQL_BIG_TABLES

  666. SQL_CALC_FOUND_ROWS

  667. SQL_LOG_OFF

  668. SQL_LOG_UPDATE

  669. SQL_LOW_PRIORITY_UPDATES

  670. SQL_SELECT_LIMIT

  671. SQL_SMALL_RESULT

  672. SQL_WARNINGS

  673. SQLCA

  674. SQLCODE

  675. SQLERROR

  676. SQLEXCEPTION

  677. SQLSTATE

  678. SQLWARNING

  679. SQRT

  680. SSL

  681. STABLE

  682. START

  683. STARTING

  684. STATE

  685. STATEMENT

  686. STATIC

  687. STATISTICS

  688. STATUS

  689. STDDEV_POP

  690. STDDEV_SAMP

  691. STDIN

  692. STDOUT

  693. STORAGE

  694. STRAIGHT_JOIN

  695. STRICT

  696. STRING

  697. STRUCTURE

  698. STYLE

  699. SUBCLASS_ORIGIN

  700. SUBLIST

  701. SUBMULTISET

  702. SUBSTRING

  703. SUCCESSFUL

  704. SUM

  705. SUPERUSER

  706. SYMMETRIC

  707. SYNONYM

  708. SYSDATE

  709. SYSID

  710. SYSTEM

  711. SYSTEM_USER

  712. TABLE

  713. TABLE_NAME

  714. TABLES

  715. TABLESAMPLE

  716. TABLESPACE

  717. TEMP

  718. TEMPLATE

  719. TEMPORARY

  720. TERMINATE

  721. TERMINATED

  722. TEXT

  723. TEXTSIZE

  724. THAN

  725. THEN

  726. TIES

  727. TIME

  728. TIMESTAMP

  729. TIMEZONE_HOUR

  730. TIMEZONE_MINUTE

  731. TINYBLOB

  732. TINYINT

  733. TINYTEXT

  734. TO

  735. TOAST

  736. TOP

  737. TOP_LEVEL_COUNT

  738. TRAILING

  739. TRAN

  740. TRANSACTION

  741. TRANSACTION_ACTIVE

  742. TRANSACTIONS_COMMITTED

  743. TRANSACTIONS_ROLLED_BACK

  744. TRANSFORM

  745. TRANSFORMS

  746. TRANSLATE

  747. TRANSLATION

  748. TREAT

  749. TRIGGER

  750. TRIGGER_CATALOG

  751. TRIGGER_NAME

  752. TRIGGER_SCHEMA

  753. TRIM

  754. TRUE

  755. TRUNCATE

  756. TRUSTED

  757. TSEQUAL

  758. TYPE

  759. UESCAPE

  760. UID

  761. UNBOUNDED

  762. UNCOMMITTED

  763. UNDER

  764. UNDO

  765. UNENCRYPTED

  766. UNION

  767. UNIQUE

  768. UNKNOWN

  769. UNLISTEN

  770. UNLOCK

  771. UNNAMED

  772. UNNEST

  773. UNSIGNED

  774. UNTIL

  775. UPDATE

  776. UPDATETEXT

  777. UPPER

  778. USAGE

  779. USE

  780. USER

  781. USER_DEFINED_TYPE_CATALOG

  782. USER_DEFINED_TYPE_CODE

  783. USER_DEFINED_TYPE_NAME

  784. USER_DEFINED_TYPE_SCHEMA

  785. USING

  786. UTC_DATE

  787. UTC_TIME

  788. UTC_TIMESTAMP

  789. VACUUM

  790. VALID

  791. VALIDATE

  792. VALIDATOR

  793. VALUE

  794. VALUES

  795. VAR_POP

  796. VAR_SAMP

  797. VARBINARY

  798. VARCHAR

  799. VARCHAR2

  800. VARCHARACTER

  801. VARIABLE

  802. VARIABLES

  803. VARYING

  804. VERBOSE

  805. VIEW

  806. VOLATILE

  807. WAITFOR

  808. WHEN

  809. WHENEVER

  810. WHERE

  811. WHILE

  812. WIDTH_BUCKET

  813. WINDOW

  814. WITH

  815. WITHIN

  816. WITHOUT

  817. WORK

  818. WRITE

  819. WRITETEXT

  820. X509

  821. XOR

  822. YEAR

  823. YEAR_MONTH

  824. ZEROFILL

  825. ZONE