Advertising sustains the DA. Ads are hidden for members. Join today

On this page

List of SQL reserved words

Last updated on
24 September 2022

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. LEAD
  367. LEADING
  368. LEAST
  369. LEAVE
  370. LEFT
  371. LENGTH
  372. LESS
  373. LEVEL
  374. LIKE
  375. LIMIT
  376. LINENO
  377. LINES
  378. LISTEN
  379. LN
  380. LOAD
  381. LOCAL
  382. LOCALTIME
  383. LOCALTIMESTAMP
  384. LOCATION
  385. LOCATOR
  386. LOCK
  387. LOGIN
  388. LOGS
  389. LONG
  390. LONGBLOB
  391. LONGTEXT
  392. LOOP
  393. LOW_PRIORITY
  394. LOWER
  395. M
  396. MAP
  397. MATCH
  398. MATCHED
  399. MAX
  400. MAX_ROWS
  401. MAXEXTENTS
  402. MAXVALUE
  403. MEDIUMBLOB
  404. MEDIUMINT
  405. MEDIUMTEXT
  406. MEMBER
  407. MERGE
  408. MESSAGE_LENGTH
  409. MESSAGE_OCTET_LENGTH
  410. MESSAGE_TEXT
  411. METHOD
  412. MIDDLEINT
  413. MIN
  414. MIN_ROWS
  415. MINUS
  416. MINUTE
  417. MINUTE_MICROSECOND
  418. MINUTE_SECOND
  419. MINVALUE
  420. MLSLABEL
  421. MOD
  422. MODE
  423. MODIFIES
  424. MODIFY
  425. MODULE
  426. MONTH
  427. MONTHNAME
  428. MORE
  429. MOVE
  430. MULTISET
  431. MUMPS
  432. MYISAM
  433. NAME
  434. NAMES
  435. NATIONAL
  436. NATURAL
  437. NCHAR
  438. NCLOB
  439. NESTING
  440. NEW
  441. NEXT
  442. NO
  443. NO_WRITE_TO_BINLOG
  444. NOAUDIT
  445. NOCHECK
  446. NOCOMPRESS
  447. NOCREATEDB
  448. NOCREATEROLE
  449. NOCREATEUSER
  450. NOINHERIT
  451. NOLOGIN
  452. NONCLUSTERED
  453. NONE
  454. NORMALIZE
  455. NORMALIZED
  456. NOSUPERUSER
  457. NOT
  458. NOTHING
  459. NOTIFY
  460. NOTNULL
  461. NOWAIT
  462. NULL
  463. NULLABLE
  464. NULLIF
  465. NULLS
  466. NUMBER
  467. NUMERIC
  468. OBJECT
  469. OCTET_LENGTH
  470. OCTETS
  471. OF
  472. OFF
  473. OFFLINE
  474. OFFSET
  475. OFFSETS
  476. OIDS
  477. OLD
  478. ON
  479. ONLINE
  480. ONLY
  481. OPEN
  482. OPENDATASOURCE
  483. OPENQUERY
  484. OPENROWSET
  485. OPENXML
  486. OPERATION
  487. OPERATOR
  488. OPTIMIZE
  489. OPTION
  490. OPTIONALLY
  491. OPTIONS
  492. OR
  493. ORDER
  494. ORDERING
  495. ORDINALITY
  496. OTHERS
  497. OUT
  498. OUTER
  499. OUTFILE
  500. OUTPUT
  501. OVER
  502. OVERLAPS
  503. OVERLAY
  504. OVERRIDING
  505. OWNER
  506. PACK_KEYS
  507. PAD
  508. PARAMETER
  509. PARAMETER_MODE
  510. PARAMETER_NAME
  511. PARAMETER_ORDINAL_POSITION
  512. PARAMETER_SPECIFIC_CATALOG
  513. PARAMETER_SPECIFIC_NAME
  514. PARAMETER_SPECIFIC_SCHEMA
  515. PARAMETERS
  516. PARTIAL
  517. PARTITION
  518. PASCAL
  519. PASSWORD
  520. PATH
  521. PCTFREE
  522. PERCENT
  523. PERCENT_RANK
  524. PERCENTILE_CONT
  525. PERCENTILE_DISC
  526. PLACING
  527. PLAN
  528. PLI
  529. POSITION
  530. POSTFIX
  531. POWER
  532. PRECEDING
  533. PRECISION
  534. PREFIX
  535. PREORDER
  536. PREPARE
  537. PREPARED
  538. PRESERVE
  539. PRIMARY
  540. PRINT
  541. PRIOR
  542. PRIVILEGES
  543. PROC
  544. PROCEDURAL
  545. PROCEDURE
  546. PROCESS
  547. PROCESSLIST
  548. PUBLIC
  549. PURGE
  550. QUOTE
  551. RAID0
  552. RAISERROR
  553. RANGE
  554. RANK
  555. RAW
  556. READ
  557. READS
  558. READTEXT
  559. REAL
  560. RECHECK
  561. RECONFIGURE
  562. RECURSIVE
  563. REF
  564. REFERENCES
  565. REFERENCING
  566. REGEXP
  567. REGR_AVGX
  568. REGR_AVGY
  569. REGR_COUNT
  570. REGR_INTERCEPT
  571. REGR_R2
  572. REGR_SLOPE
  573. REGR_SXX
  574. REGR_SXY
  575. REGR_SYY
  576. REINDEX
  577. RELATIVE
  578. RELEASE
  579. RELOAD
  580. RENAME
  581. REPEAT
  582. REPEATABLE
  583. REPLACE
  584. REPLICATION
  585. REQUIRE
  586. RESET
  587. RESIGNAL
  588. RESOURCE
  589. RESTART
  590. RESTORE
  591. RESTRICT
  592. RESULT
  593. RETURN
  594. RETURNED_CARDINALITY
  595. RETURNED_LENGTH
  596. RETURNED_OCTET_LENGTH
  597. RETURNED_SQLSTATE
  598. RETURNS
  599. REVOKE
  600. RIGHT
  601. RLIKE
  602. ROLE
  603. ROLLBACK
  604. ROLLUP
  605. ROUTINE
  606. ROUTINE_CATALOG
  607. ROUTINE_NAME
  608. ROUTINE_SCHEMA
  609. ROW
  610. ROW_COUNT
  611. ROW_NUMBER
  612. ROWCOUNT
  613. ROWGUIDCOL
  614. ROWID
  615. ROWNUM
  616. ROWS
  617. RULE
  618. SAVE
  619. SAVEPOINT
  620. SCALE
  621. SCHEMA
  622. SCHEMA_NAME
  623. SCHEMAS
  624. SCOPE
  625. SCOPE_CATALOG
  626. SCOPE_NAME
  627. SCOPE_SCHEMA
  628. SCROLL
  629. SEARCH
  630. SECOND
  631. SECOND_MICROSECOND
  632. SECTION
  633. SECURITY
  634. SELECT
  635. SELF
  636. SENSITIVE
  637. SEPARATOR
  638. SEQUENCE
  639. SERIALIZABLE
  640. SERVER_NAME
  641. SESSION
  642. SESSION_USER
  643. SET
  644. SETOF
  645. SETS
  646. SETUSER
  647. SHARE
  648. SHOW
  649. SHUTDOWN
  650. SIGNAL
  651. SIMILAR
  652. SIMPLE
  653. SIZE
  654. SMALLINT
  655. SOME
  656. SONAME
  657. SOURCE
  658. SPACE
  659. SPATIAL
  660. SPECIFIC
  661. SPECIFIC_NAME
  662. SPECIFICTYPE
  663. SQL
  664. SQL_BIG_RESULT
  665. SQL_BIG_SELECTS
  666. SQL_BIG_TABLES
  667. SQL_CALC_FOUND_ROWS
  668. SQL_LOG_OFF
  669. SQL_LOG_UPDATE
  670. SQL_LOW_PRIORITY_UPDATES
  671. SQL_SELECT_LIMIT
  672. SQL_SMALL_RESULT
  673. SQL_WARNINGS
  674. SQLCA
  675. SQLCODE
  676. SQLERROR
  677. SQLEXCEPTION
  678. SQLSTATE
  679. SQLWARNING
  680. SQRT
  681. SSL
  682. STABLE
  683. START
  684. STARTING
  685. STATE
  686. STATEMENT
  687. STATIC
  688. STATISTICS
  689. STATUS
  690. STDDEV_POP
  691. STDDEV_SAMP
  692. STDIN
  693. STDOUT
  694. STORAGE
  695. STRAIGHT_JOIN
  696. STRICT
  697. STRING
  698. STRUCTURE
  699. STYLE
  700. SUBCLASS_ORIGIN
  701. SUBLIST
  702. SUBMULTISET
  703. SUBSTRING
  704. SUCCESSFUL
  705. SUM
  706. SUPERUSER
  707. SYMMETRIC
  708. SYNONYM
  709. SYSDATE
  710. SYSID
  711. SYSTEM
  712. SYSTEM_USER
  713. TABLE
  714. TABLE_NAME
  715. TABLES
  716. TABLESAMPLE
  717. TABLESPACE
  718. TEMP
  719. TEMPLATE
  720. TEMPORARY
  721. TERMINATE
  722. TERMINATED
  723. TEXT
  724. TEXTSIZE
  725. THAN
  726. THEN
  727. TIES
  728. TIME
  729. TIMESTAMP
  730. TIMEZONE_HOUR
  731. TIMEZONE_MINUTE
  732. TINYBLOB
  733. TINYINT
  734. TINYTEXT
  735. TO
  736. TOAST
  737. TOP
  738. TOP_LEVEL_COUNT
  739. TRAILING
  740. TRAN
  741. TRANSACTION
  742. TRANSACTION_ACTIVE
  743. TRANSACTIONS_COMMITTED
  744. TRANSACTIONS_ROLLED_BACK
  745. TRANSFORM
  746. TRANSFORMS
  747. TRANSLATE
  748. TRANSLATION
  749. TREAT
  750. TRIGGER
  751. TRIGGER_CATALOG
  752. TRIGGER_NAME
  753. TRIGGER_SCHEMA
  754. TRIM
  755. TRUE
  756. TRUNCATE
  757. TRUSTED
  758. TSEQUAL
  759. TYPE
  760. UESCAPE
  761. UID
  762. UNBOUNDED
  763. UNCOMMITTED
  764. UNDER
  765. UNDO
  766. UNENCRYPTED
  767. UNION
  768. UNIQUE
  769. UNKNOWN
  770. UNLISTEN
  771. UNLOCK
  772. UNNAMED
  773. UNNEST
  774. UNSIGNED
  775. UNTIL
  776. UPDATE
  777. UPDATETEXT
  778. UPPER
  779. USAGE
  780. USE
  781. USER
  782. USER_DEFINED_TYPE_CATALOG
  783. USER_DEFINED_TYPE_CODE
  784. USER_DEFINED_TYPE_NAME
  785. USER_DEFINED_TYPE_SCHEMA
  786. USING
  787. UTC_DATE
  788. UTC_TIME
  789. UTC_TIMESTAMP
  790. VACUUM
  791. VALID
  792. VALIDATE
  793. VALIDATOR
  794. VALUE
  795. VALUES
  796. VAR_POP
  797. VAR_SAMP
  798. VARBINARY
  799. VARCHAR
  800. VARCHAR2
  801. VARCHARACTER
  802. VARIABLE
  803. VARIABLES
  804. VARYING
  805. VERBOSE
  806. VIEW
  807. VOLATILE
  808. WAITFOR
  809. WHEN
  810. WHENEVER
  811. WHERE
  812. WHILE
  813. WIDTH_BUCKET
  814. WINDOW
  815. WITH
  816. WITHIN
  817. WITHOUT
  818. WORK
  819. WRITE
  820. WRITETEXT
  821. X509
  822. XOR
  823. YEAR
  824. YEAR_MONTH
  825. ZEROFILL
  826. ZONE

Help improve this page

Page status: No known problems

You can: