sql.syntax 11 KB

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