sql.syntax 16 KB

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