SQL Reserved words

 

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

  • ANSI SQL 92

 

  • ANSI SQL 99

 

  • ANSI SQL 2003

 

  • MySQL 3.23.x

 

  • MySQL 4.x

 

  • MySQL 5.x

 

  • PostGreSQL 8.1

 

  • MS SQL Server 2000

 

  • MS ODBC

 

  • Oracle 10.2

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

  1. COLLECT
  2. COLUMN
  3. COLUMN_NAME
  4. COLUMNS
  5. COMMAND_FUNCTION
  6. COMMAND_FUNCTION_CODE
  7. COMMENT
  8. COMMIT

 

 

 

Registration


A password will be e-mailed to you.

Feedback Form

Name (required)

Email (required)

Feedback