sql.syntax 10.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344
  1. # SQL syntax highlighting for CoolEdit
  2. # by Walery Studennikov <despair@sama.ru>
  3. caseinsensitive
  4. context default
  5. keyword whole abort yellow
  6. keyword whole absolute yellow
  7. keyword whole action yellow
  8. keyword whole ada yellow
  9. keyword whole add yellow
  10. keyword whole all yellow
  11. keyword whole allocate yellow
  12. keyword whole alter yellow
  13. keyword whole and yellow
  14. keyword whole any yellow
  15. keyword whole are yellow
  16. keyword whole as yellow
  17. keyword whole asc yellow
  18. keyword whole assertion yellow
  19. keyword whole at yellow
  20. keyword whole authorization yellow
  21. keyword whole auto_increment yellow
  22. keyword whole begin yellow
  23. keyword whole between yellow
  24. keyword whole bigint yellow
  25. keyword whole bit yellow
  26. keyword whole bit_length yellow
  27. keyword whole blob yellow
  28. keyword whole both yellow
  29. keyword whole by yellow
  30. keyword whole cascade yellow
  31. keyword whole cascaded yellow
  32. keyword whole case yellow
  33. keyword whole cast yellow
  34. keyword whole catalog yellow
  35. keyword whole char yellow
  36. keyword whole char_length yellow
  37. keyword whole character yellow
  38. keyword whole character_length yellow
  39. keyword whole check yellow
  40. keyword whole close yellow
  41. keyword whole coalesce yellow
  42. keyword whole collate yellow
  43. keyword whole collation yellow
  44. keyword whole column yellow
  45. keyword whole commit yellow
  46. keyword whole compile yellow
  47. keyword whole connect yellow
  48. keyword whole connection yellow
  49. keyword whole constraint yellow
  50. keyword whole constraint yellow
  51. keyword whole constraints yellow
  52. keyword whole continue yellow
  53. keyword whole copy yellow
  54. keyword whole corresponding yellow
  55. keyword whole create yellow
  56. keyword whole cross yellow
  57. keyword whole current yellow
  58. keyword whole current_date yellow
  59. keyword whole current_time yellow
  60. keyword whole current_timestamp yellow
  61. keyword whole current_user yellow
  62. keyword whole cursor yellow
  63. keyword whole database yellow
  64. keyword whole date yellow
  65. keyword whole datetime yellow
  66. keyword whole day yellow
  67. keyword whole deallocate yellow
  68. keyword whole dec yellow
  69. keyword whole decimal yellow
  70. keyword whole declare yellow
  71. keyword whole default yellow
  72. keyword whole deferrable yellow
  73. keyword whole deferred yellow
  74. keyword whole delete yellow
  75. keyword whole desc yellow
  76. keyword whole describe yellow
  77. keyword whole descriptor yellow
  78. keyword whole diagnostics yellow
  79. keyword whole disconnect yellow
  80. keyword whole distinct yellow
  81. keyword whole domain yellow
  82. keyword whole double yellow
  83. keyword whole drop yellow
  84. keyword whole else yellow
  85. keyword whole encoding yellow
  86. keyword whole end yellow
  87. keyword whole end-exec yellow
  88. keyword whole enum yellow
  89. keyword whole escape yellow
  90. keyword whole except yellow
  91. keyword whole exception yellow
  92. keyword whole exec yellow
  93. keyword whole execute yellow
  94. keyword whole exists yellow
  95. keyword whole external yellow
  96. keyword whole extract yellow
  97. keyword whole false yellow
  98. keyword whole fetch yellow
  99. keyword whole first yellow
  100. keyword whole float yellow
  101. keyword whole for yellow
  102. keyword whole foreign yellow
  103. keyword whole fortran yellow
  104. keyword whole found yellow
  105. keyword whole from yellow
  106. keyword whole full yellow
  107. keyword whole get yellow
  108. keyword whole global yellow
  109. keyword whole go yellow
  110. keyword whole goto yellow
  111. keyword whole grant yellow
  112. keyword whole group yellow
  113. keyword whole having yellow
  114. keyword whole hour yellow
  115. keyword whole identity yellow
  116. keyword whole if yellow
  117. keyword whole immediate yellow
  118. keyword whole in yellow
  119. keyword whole include yellow
  120. keyword whole index yellow
  121. keyword whole indicator yellow
  122. keyword whole initially yellow
  123. keyword whole inner yellow
  124. keyword whole input yellow
  125. keyword whole insensitive yellow
  126. keyword whole insert yellow
  127. keyword whole int yellow
  128. keyword whole integer yellow
  129. keyword whole intersect yellow
  130. keyword whole interval yellow
  131. keyword whole into yellow
  132. keyword whole is yellow
  133. keyword whole isolation yellow
  134. keyword whole join yellow
  135. keyword whole key yellow
  136. keyword whole key yellow
  137. keyword whole language yellow
  138. keyword whole last yellow
  139. keyword whole leading yellow
  140. keyword whole left yellow
  141. keyword whole level yellow
  142. keyword whole like yellow
  143. keyword whole local yellow
  144. keyword whole lock yellow
  145. keyword whole longblob yellow
  146. keyword whole longtext yellow
  147. keyword whole loop yellow
  148. keyword whole match yellow
  149. keyword whole mediumblob yellow
  150. keyword whole mediumint yellow
  151. keyword whole mediumtext yellow
  152. keyword whole merge yellow
  153. keyword whole minute yellow
  154. keyword whole minus yellow
  155. keyword whole module yellow
  156. keyword whole month yellow
  157. keyword whole names yellow
  158. keyword whole national yellow
  159. keyword whole natural yellow
  160. keyword whole nchar yellow
  161. keyword whole next yellow
  162. keyword whole no yellow
  163. keyword whole none yellow
  164. keyword whole not yellow
  165. keyword whole null yellow
  166. keyword whole nullif yellow
  167. keyword whole numeric yellow
  168. keyword whole octet_length yellow
  169. keyword whole of yellow
  170. keyword whole offline yellow
  171. keyword whole on yellow
  172. keyword whole online yellow
  173. keyword whole only yellow
  174. keyword whole open yellow
  175. keyword whole option yellow
  176. keyword whole or yellow
  177. keyword whole order yellow
  178. keyword whole outer yellow
  179. keyword whole output yellow
  180. keyword whole overlaps yellow
  181. keyword whole pad yellow
  182. keyword whole partial yellow
  183. keyword whole pascal yellow
  184. keyword whole position yellow
  185. keyword whole precision yellow
  186. keyword whole prepare yellow
  187. keyword whole preserve yellow
  188. keyword whole primary yellow
  189. keyword whole primary yellow
  190. keyword whole prior yellow
  191. keyword whole privileges yellow
  192. keyword whole procedure yellow
  193. keyword whole public yellow
  194. keyword whole read yellow
  195. keyword whole real yellow
  196. keyword whole rebuild yellow
  197. keyword whole references yellow
  198. keyword whole relative yellow
  199. keyword whole replace yellow
  200. keyword whole restrict yellow
  201. keyword whole revoke yellow
  202. keyword whole right yellow
  203. keyword whole rollback yellow
  204. keyword whole rows yellow
  205. keyword whole schema yellow
  206. keyword whole scroll yellow
  207. keyword whole second yellow
  208. keyword whole section yellow
  209. keyword whole select yellow
  210. keyword whole sequence yellow
  211. keyword whole session yellow
  212. keyword whole session_user yellow
  213. keyword whole set yellow
  214. keyword whole size yellow
  215. keyword whole smallint yellow
  216. keyword whole some yellow
  217. keyword whole space yellow
  218. keyword whole sql yellow
  219. keyword whole sqlca yellow
  220. keyword whole sqlstate yellow
  221. keyword whole sqlwarning yellow
  222. keyword whole substring yellow
  223. keyword whole system_user yellow
  224. keyword whole table yellow
  225. keyword whole tablespace yellow
  226. keyword whole template yellow
  227. keyword whole temporary yellow
  228. keyword whole text yellow
  229. keyword whole then yellow
  230. keyword whole time yellow
  231. keyword whole truncate yellow
  232. keyword whole timestamp yellow
  233. keyword whole timezone_hour yellow
  234. keyword whole timezone_minute yellow
  235. keyword whole tinyblob yellow
  236. keyword whole tinyint yellow
  237. keyword whole tinytext yellow
  238. keyword whole to yellow
  239. keyword whole trailing yellow
  240. keyword whole transaction yellow
  241. keyword whole translation yellow
  242. keyword whole trigger yellow
  243. keyword whole trim yellow
  244. keyword whole true yellow
  245. keyword whole type yellow
  246. keyword whole union yellow
  247. keyword whole unique yellow
  248. keyword whole unknown yellow
  249. keyword whole unsigned yellow
  250. keyword whole update yellow
  251. keyword whole usage yellow
  252. keyword whole use yellow
  253. keyword whole user yellow
  254. keyword whole using yellow
  255. keyword whole value yellow
  256. keyword whole values yellow
  257. keyword whole varchar yellow
  258. keyword whole varying yellow
  259. keyword whole view yellow
  260. keyword whole when yellow
  261. keyword whole whenever yellow
  262. keyword whole where yellow
  263. keyword whole while yellow
  264. keyword whole with yellow
  265. keyword whole work yellow
  266. keyword whole write yellow
  267. keyword whole year yellow
  268. keyword whole zone yellow
  269. keyword /\* brown
  270. keyword \*/ brown
  271. keyword -- brown
  272. keyword > brightcyan
  273. keyword < brightcyan
  274. keyword \+ brightcyan
  275. keyword - brightcyan
  276. keyword \* brightcyan
  277. keyword / brightcyan
  278. keyword % brightcyan
  279. keyword = brightcyan
  280. keyword ( brightcyan
  281. keyword ) brightcyan
  282. keyword , brightcyan
  283. keyword ; brightcyan
  284. keyword . white
  285. # PostgreSQL specific
  286. keyword aggregate yellow
  287. keyword checkpoint yellow
  288. keyword cluster yellow
  289. keyword conversion yellow
  290. keyword listen yellow
  291. keyword notify yellow
  292. keyword operator yellow
  293. keyword reindex yellow
  294. keyword savepoint yellow
  295. keyword unlisten yellow
  296. keyword vacuum yellow
  297. keyword createdb white
  298. keyword createuser white
  299. keyword nocreatedb white
  300. keyword nocreateuser white
  301. keyword password white
  302. keyword sysid white
  303. keyword currval white
  304. keyword nextval white
  305. keyword pg_database white
  306. keyword pg_group white
  307. keyword pg_shadow white
  308. keyword setval white
  309. keyword stdin white
  310. # PostgreSQL sequences
  311. keyword cache white
  312. keyword increment white
  313. keyword maxvalue white
  314. keyword minvalue white
  315. keyword start white
  316. # MySQL comment
  317. context linestart # \n brown
  318. spellcheck
  319. # ANSI SQL comment
  320. context exclusive -- \n brown
  321. spellcheck
  322. context exclusive /\* \*/ brown
  323. spellcheck
  324. context ' ' green
  325. keyword \\' green
  326. context " " green
  327. keyword \\" green
  328. # Beckticks are used to escape reserved words in MySQL
  329. context ` ` cyan
  330. keyword . white