Last updated July 23, 2010. Created by ff1 on May 3, 2007.
Edited by duellj, kiamlaluno. Log in to edit this page.

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

Looking for support? Visit the Drupal.org forums, or join #drupal-support in IRC.