sql.syntax 15 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492
  1. # SQL syntax highlighting for CoolEdit
  2. # by Walery Studennikov <despair@sama.ru>
  3. context default
  4. keyword whole ABSOLUTE yellow
  5. keyword whole ACTION yellow
  6. keyword whole ADA yellow
  7. keyword whole ADD yellow
  8. keyword whole ALL yellow
  9. keyword whole ALLOCATE yellow
  10. keyword whole ALTER yellow
  11. keyword whole AND yellow
  12. keyword whole ANY yellow
  13. keyword whole ARE yellow
  14. keyword whole AS yellow
  15. keyword whole ASC yellow
  16. keyword whole ASSERTION yellow
  17. keyword whole AT yellow
  18. keyword whole AUTHORIZATION yellow
  19. keyword whole AUTO_INCREMENT yellow
  20. keyword whole BEGIN yellow
  21. keyword whole BETWEEN yellow
  22. keyword whole BIGINT yellow
  23. keyword whole BIT yellow
  24. keyword whole BIT_LENGTH yellow
  25. keyword whole BOTH yellow
  26. keyword whole BY yellow
  27. keyword whole CASCADE yellow
  28. keyword whole CASCADED yellow
  29. keyword whole CASE yellow
  30. keyword whole CAST yellow
  31. keyword whole CATALOG yellow
  32. keyword whole CHAR yellow
  33. keyword whole CHAR_LENGTH yellow
  34. keyword whole CHARACTER yellow
  35. keyword whole CHARACTER_LENGTH yellow
  36. keyword whole CHECK yellow
  37. keyword whole CLOSE yellow
  38. keyword whole COALESCE yellow
  39. keyword whole COLLATE yellow
  40. keyword whole COLLATION yellow
  41. keyword whole COLUMN yellow
  42. keyword whole COMMIT yellow
  43. keyword whole CONNECT yellow
  44. keyword whole CONNECTION yellow
  45. keyword whole CONSTRAINT yellow
  46. keyword whole CONSTRAINTS yellow
  47. keyword whole CONTINUE yellow
  48. keyword whole CORRESPONDING yellow
  49. keyword whole CREATE yellow
  50. keyword whole CROSS yellow
  51. keyword whole CURRENT yellow
  52. keyword whole CURRENT_DATE yellow
  53. keyword whole CURRENT_TIME yellow
  54. keyword whole CURRENT_TIMESTAMP yellow
  55. keyword whole CURRENT_USER yellow
  56. keyword whole CURSOR yellow
  57. keyword whole DATE yellow
  58. keyword whole DAY yellow
  59. keyword whole DEALLOCATE yellow
  60. keyword whole DEC yellow
  61. keyword whole DECIMAL yellow
  62. keyword whole DECLARE yellow
  63. keyword whole DEFAULT yellow
  64. keyword whole DEFERRABLE yellow
  65. keyword whole DEFERRED yellow
  66. keyword whole DELETE yellow
  67. keyword whole DESC yellow
  68. keyword whole DESCRIBE yellow
  69. keyword whole DESCRIPTOR yellow
  70. keyword whole DIAGNOSTICS yellow
  71. keyword whole DISCONNECT yellow
  72. keyword whole DISTINCT yellow
  73. keyword whole DOMAIN yellow
  74. keyword whole DOUBLE yellow
  75. keyword whole DROP yellow
  76. keyword whole ELSE yellow
  77. keyword whole END yellow
  78. keyword whole END-EXEC yellow
  79. keyword whole ESCAPE yellow
  80. keyword whole EXCEPT yellow
  81. keyword whole EXCEPTION yellow
  82. keyword whole EXEC yellow
  83. keyword whole EXECUTE yellow
  84. keyword whole EXISTS yellow
  85. keyword whole EXTERNAL yellow
  86. keyword whole EXTRACT yellow
  87. keyword whole FALSE yellow
  88. keyword whole FETCH yellow
  89. keyword whole FIRST yellow
  90. keyword whole FLOAT yellow
  91. keyword whole FOR yellow
  92. keyword whole FOREIGN yellow
  93. keyword whole FORTRAN yellow
  94. keyword whole FOUND yellow
  95. keyword whole FROM yellow
  96. keyword whole FULL yellow
  97. keyword whole GET yellow
  98. keyword whole GLOBAL yellow
  99. keyword whole GO yellow
  100. keyword whole GOTO yellow
  101. keyword whole GRANT yellow
  102. keyword whole GROUP yellow
  103. keyword whole HAVING yellow
  104. keyword whole HOUR yellow
  105. keyword whole IDENTITY yellow
  106. keyword whole IF yellow
  107. keyword whole IMMEDIATE yellow
  108. keyword whole IN yellow
  109. keyword whole INCLUDE yellow
  110. keyword whole INDEX yellow
  111. keyword whole INDICATOR yellow
  112. keyword whole INITIALLY yellow
  113. keyword whole INNER yellow
  114. keyword whole INPUT yellow
  115. keyword whole INSENSITIVE yellow
  116. keyword whole INSERT yellow
  117. keyword whole INT yellow
  118. keyword whole INTEGER yellow
  119. keyword whole INTERSECT yellow
  120. keyword whole INTERVAL yellow
  121. keyword whole INTO yellow
  122. keyword whole IS yellow
  123. keyword whole ISOLATION yellow
  124. keyword whole JOIN yellow
  125. keyword whole KEY yellow
  126. keyword whole LANGUAGE yellow
  127. keyword whole LAST yellow
  128. keyword whole LEADING yellow
  129. keyword whole LEFT yellow
  130. keyword whole LEVEL yellow
  131. keyword whole LIKE yellow
  132. keyword whole LOCAL yellow
  133. keyword whole LOCK yellow
  134. keyword whole LOOP yellow
  135. keyword whole MATCH yellow
  136. keyword whole MINUTE yellow
  137. keyword whole MODULE yellow
  138. keyword whole MONTH yellow
  139. keyword whole NAMES yellow
  140. keyword whole NATIONAL yellow
  141. keyword whole NATURAL yellow
  142. keyword whole NCHAR yellow
  143. keyword whole NEXT yellow
  144. keyword whole NO yellow
  145. keyword whole NONE yellow
  146. keyword whole NOT yellow
  147. keyword whole NULL yellow
  148. keyword whole NULLIF yellow
  149. keyword whole NUMERIC yellow
  150. keyword whole OCTET_LENGTH yellow
  151. keyword whole OF yellow
  152. keyword whole ON yellow
  153. keyword whole ONLY yellow
  154. keyword whole OPEN yellow
  155. keyword whole OPTION yellow
  156. keyword whole OR yellow
  157. keyword whole ORDER yellow
  158. keyword whole OUTER yellow
  159. keyword whole OUTPUT yellow
  160. keyword whole OVERLAPS yellow
  161. keyword whole PAD yellow
  162. keyword whole PARTIAL yellow
  163. keyword whole PASCAL yellow
  164. keyword whole POSITION yellow
  165. keyword whole PRECISION yellow
  166. keyword whole PREPARE yellow
  167. keyword whole PRESERVE yellow
  168. keyword whole PRIMARY yellow
  169. keyword whole PRIOR yellow
  170. keyword whole PRIVILEGES yellow
  171. keyword whole PROCEDURE yellow
  172. keyword whole PUBLIC yellow
  173. keyword whole READ yellow
  174. keyword whole REAL yellow
  175. keyword whole REFERENCES yellow
  176. keyword whole RELATIVE yellow
  177. keyword whole RESTRICT yellow
  178. keyword whole REVOKE yellow
  179. keyword whole RIGHT yellow
  180. keyword whole ROLLBACK yellow
  181. keyword whole ROWS yellow
  182. keyword whole SCHEMA yellow
  183. keyword whole SCROLL yellow
  184. keyword whole SECOND yellow
  185. keyword whole SECTION yellow
  186. keyword whole SELECT yellow
  187. keyword whole SESSION yellow
  188. keyword whole SESSION_USER yellow
  189. keyword whole SET yellow
  190. keyword whole SIZE yellow
  191. keyword whole SMALLINT yellow
  192. keyword whole SOME yellow
  193. keyword whole SPACE yellow
  194. keyword whole SQL yellow
  195. keyword whole SQLCA yellow
  196. keyword whole SQLSTATE yellow
  197. keyword whole SQLWARNING yellow
  198. keyword whole SUBSTRING yellow
  199. keyword whole SYSTEM_USER yellow
  200. keyword whole TABLE yellow
  201. keyword whole TEMPORARY yellow
  202. keyword whole THEN yellow
  203. keyword whole TIME yellow
  204. keyword whole TIMESTAMP yellow
  205. keyword whole TIMEZONE_HOUR yellow
  206. keyword whole TIMEZONE_MINUTE yellow
  207. keyword whole TO yellow
  208. keyword whole TRAILING yellow
  209. keyword whole TRANSACTION yellow
  210. keyword whole TRANSLATION yellow
  211. keyword whole TRIM yellow
  212. keyword whole TRUE yellow
  213. keyword whole UNION yellow
  214. keyword whole UNIQUE yellow
  215. keyword whole UNKNOWN yellow
  216. keyword whole UPDATE yellow
  217. keyword whole USAGE yellow
  218. keyword whole USING yellow
  219. keyword whole VALUE yellow
  220. keyword whole VALUES yellow
  221. keyword whole VARCHAR yellow
  222. keyword whole VARYING yellow
  223. keyword whole VIEW yellow
  224. keyword whole WHEN yellow
  225. keyword whole WHENEVER yellow
  226. keyword whole WHERE yellow
  227. keyword whole WITH yellow
  228. keyword whole WORK yellow
  229. keyword whole WRITE yellow
  230. keyword whole YEAR yellow
  231. keyword whole ZONE yellow
  232. keyword whole absolute yellow
  233. keyword whole action yellow
  234. keyword whole ada yellow
  235. keyword whole add yellow
  236. keyword whole all yellow
  237. keyword whole allocate yellow
  238. keyword whole alter yellow
  239. keyword whole and yellow
  240. keyword whole any yellow
  241. keyword whole are yellow
  242. keyword whole as yellow
  243. keyword whole asc yellow
  244. keyword whole assertion yellow
  245. keyword whole at yellow
  246. keyword whole authorization yellow
  247. keyword whole auto_increment yellow
  248. keyword whole begin yellow
  249. keyword whole between yellow
  250. keyword whole bigint yellow
  251. keyword whole bit yellow
  252. keyword whole bit_length yellow
  253. keyword whole both yellow
  254. keyword whole by yellow
  255. keyword whole cascade yellow
  256. keyword whole cascaded yellow
  257. keyword whole case yellow
  258. keyword whole cast yellow
  259. keyword whole catalog yellow
  260. keyword whole char yellow
  261. keyword whole char_length yellow
  262. keyword whole character yellow
  263. keyword whole character_length yellow
  264. keyword whole check yellow
  265. keyword whole close yellow
  266. keyword whole coalesce yellow
  267. keyword whole collate yellow
  268. keyword whole collation yellow
  269. keyword whole column yellow
  270. keyword whole commit yellow
  271. keyword whole connect yellow
  272. keyword whole connection yellow
  273. keyword whole constraint yellow
  274. keyword whole constraints yellow
  275. keyword whole continue yellow
  276. keyword whole corresponding yellow
  277. keyword whole create yellow
  278. keyword whole cross yellow
  279. keyword whole current yellow
  280. keyword whole current_date yellow
  281. keyword whole current_time yellow
  282. keyword whole current_timestamp yellow
  283. keyword whole current_user yellow
  284. keyword whole cursor yellow
  285. keyword whole date yellow
  286. keyword whole day yellow
  287. keyword whole deallocate yellow
  288. keyword whole dec yellow
  289. keyword whole decimal yellow
  290. keyword whole declare yellow
  291. keyword whole default yellow
  292. keyword whole deferrable yellow
  293. keyword whole deferred yellow
  294. keyword whole delete yellow
  295. keyword whole desc yellow
  296. keyword whole describe yellow
  297. keyword whole descriptor yellow
  298. keyword whole diagnostics yellow
  299. keyword whole disconnect yellow
  300. keyword whole distinct yellow
  301. keyword whole domain yellow
  302. keyword whole double yellow
  303. keyword whole drop yellow
  304. keyword whole else yellow
  305. keyword whole end yellow
  306. keyword whole end-exec yellow
  307. keyword whole escape yellow
  308. keyword whole except yellow
  309. keyword whole exception yellow
  310. keyword whole exec yellow
  311. keyword whole execute yellow
  312. keyword whole exists yellow
  313. keyword whole external yellow
  314. keyword whole extract yellow
  315. keyword whole false yellow
  316. keyword whole fetch yellow
  317. keyword whole first yellow
  318. keyword whole float yellow
  319. keyword whole for yellow
  320. keyword whole foreign yellow
  321. keyword whole fortran yellow
  322. keyword whole found yellow
  323. keyword whole from yellow
  324. keyword whole full yellow
  325. keyword whole get yellow
  326. keyword whole global yellow
  327. keyword whole go yellow
  328. keyword whole goto yellow
  329. keyword whole grant yellow
  330. keyword whole group yellow
  331. keyword whole having yellow
  332. keyword whole hour yellow
  333. keyword whole identity yellow
  334. keyword whole if yellow
  335. keyword whole immediate yellow
  336. keyword whole in yellow
  337. keyword whole include yellow
  338. keyword whole index yellow
  339. keyword whole indicator yellow
  340. keyword whole initially yellow
  341. keyword whole inner yellow
  342. keyword whole input yellow
  343. keyword whole insensitive yellow
  344. keyword whole insert yellow
  345. keyword whole int yellow
  346. keyword whole integer yellow
  347. keyword whole intersect yellow
  348. keyword whole interval yellow
  349. keyword whole into yellow
  350. keyword whole is yellow
  351. keyword whole isolation yellow
  352. keyword whole join yellow
  353. keyword whole key yellow
  354. keyword whole language yellow
  355. keyword whole last yellow
  356. keyword whole leading yellow
  357. keyword whole left yellow
  358. keyword whole level yellow
  359. keyword whole like yellow
  360. keyword whole local yellow
  361. keyword whole lock yellow
  362. keyword whole loop yellow
  363. keyword whole match yellow
  364. keyword whole minute yellow
  365. keyword whole module yellow
  366. keyword whole month yellow
  367. keyword whole names yellow
  368. keyword whole national yellow
  369. keyword whole natural yellow
  370. keyword whole nchar yellow
  371. keyword whole next yellow
  372. keyword whole no yellow
  373. keyword whole none yellow
  374. keyword whole not yellow
  375. keyword whole null yellow
  376. keyword whole nullif yellow
  377. keyword whole numeric yellow
  378. keyword whole octet_length yellow
  379. keyword whole of yellow
  380. keyword whole on yellow
  381. keyword whole only yellow
  382. keyword whole open yellow
  383. keyword whole option yellow
  384. keyword whole or yellow
  385. keyword whole order yellow
  386. keyword whole outer yellow
  387. keyword whole output yellow
  388. keyword whole overlaps yellow
  389. keyword whole pad yellow
  390. keyword whole partial yellow
  391. keyword whole pascal yellow
  392. keyword whole position yellow
  393. keyword whole precision yellow
  394. keyword whole prepare yellow
  395. keyword whole preserve yellow
  396. keyword whole primary yellow
  397. keyword whole prior yellow
  398. keyword whole privileges yellow
  399. keyword whole procedure yellow
  400. keyword whole public yellow
  401. keyword whole read yellow
  402. keyword whole real yellow
  403. keyword whole references yellow
  404. keyword whole relative yellow
  405. keyword whole restrict yellow
  406. keyword whole revoke yellow
  407. keyword whole right yellow
  408. keyword whole rollback yellow
  409. keyword whole rows yellow
  410. keyword whole schema yellow
  411. keyword whole scroll yellow
  412. keyword whole second yellow
  413. keyword whole section yellow
  414. keyword whole select yellow
  415. keyword whole session yellow
  416. keyword whole session_user yellow
  417. keyword whole set yellow
  418. keyword whole size yellow
  419. keyword whole smallint yellow
  420. keyword whole some yellow
  421. keyword whole space yellow
  422. keyword whole sql yellow
  423. keyword whole sqlca yellow
  424. keyword whole sqlstate yellow
  425. keyword whole sqlwarning yellow
  426. keyword whole substring yellow
  427. keyword whole system_user yellow
  428. keyword whole table yellow
  429. keyword whole temporary yellow
  430. keyword whole then yellow
  431. keyword whole time yellow
  432. keyword whole timestamp yellow
  433. keyword whole timezone_hour yellow
  434. keyword whole timezone_minute yellow
  435. keyword whole to yellow
  436. keyword whole trailing yellow
  437. keyword whole transaction yellow
  438. keyword whole translation yellow
  439. keyword whole trim yellow
  440. keyword whole true yellow
  441. keyword whole union yellow
  442. keyword whole unique yellow
  443. keyword whole unknown yellow
  444. keyword whole update yellow
  445. keyword whole usage yellow
  446. keyword whole using yellow
  447. keyword whole value yellow
  448. keyword whole values yellow
  449. keyword whole varchar yellow
  450. keyword whole varying yellow
  451. keyword whole view yellow
  452. keyword whole when yellow
  453. keyword whole whenever yellow
  454. keyword whole where yellow
  455. keyword whole with yellow
  456. keyword whole work yellow
  457. keyword whole write yellow
  458. keyword whole year yellow
  459. keyword whole zone yellow
  460. keyword /\* brown
  461. keyword \*/ brown
  462. keyword -- brown
  463. keyword > brightcyan
  464. keyword < brightcyan
  465. keyword \+ brightcyan
  466. keyword - brightcyan
  467. keyword \* brightcyan
  468. keyword / brightcyan
  469. keyword % brightcyan
  470. keyword = brightcyan
  471. keyword ( brightcyan
  472. keyword ) brightcyan
  473. keyword , brightcyan
  474. keyword ; brightcyan
  475. # MySQL comment
  476. context linestart # \n brown
  477. spellcheck
  478. # ANSI SQL comment
  479. context exclusive -- \n brown
  480. spellcheck
  481. context exclusive /\* \*/ brown
  482. spellcheck
  483. context ' ' green
  484. context " " green