sql.syntax 19 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626
  1. # SQL syntax highlighting for CoolEdit
  2. # by Walery Studennikov <despair@sama.ru>
  3. context default
  4. keyword whole ABORT yellow
  5. keyword whole ABSOLUTE yellow
  6. keyword whole ACTION yellow
  7. keyword whole ADA yellow
  8. keyword whole ADD yellow
  9. keyword whole ALL yellow
  10. keyword whole ALLOCATE yellow
  11. keyword whole ALTER yellow
  12. keyword whole AND yellow
  13. keyword whole ANY yellow
  14. keyword whole ARE yellow
  15. keyword whole AS yellow
  16. keyword whole ASC yellow
  17. keyword whole ASSERTION yellow
  18. keyword whole AT yellow
  19. keyword whole AUTHORIZATION yellow
  20. keyword whole AUTO_INCREMENT yellow
  21. keyword whole BEGIN yellow
  22. keyword whole BETWEEN yellow
  23. keyword whole BIGINT yellow
  24. keyword whole BIT yellow
  25. keyword whole BIT_LENGTH yellow
  26. keyword whole BLOB yellow
  27. keyword whole BOTH yellow
  28. keyword whole BY yellow
  29. keyword whole CASCADE yellow
  30. keyword whole CASCADED yellow
  31. keyword whole CASE yellow
  32. keyword whole CAST yellow
  33. keyword whole CATALOG yellow
  34. keyword whole CHAR yellow
  35. keyword whole CHARACTER yellow
  36. keyword whole CHARACTER_LENGTH yellow
  37. keyword whole CHAR_LENGTH yellow
  38. keyword whole CHECK yellow
  39. keyword whole CLOSE yellow
  40. keyword whole COALESCE yellow
  41. keyword whole COLLATE yellow
  42. keyword whole COLLATION yellow
  43. keyword whole COLUMN yellow
  44. keyword whole COMMIT yellow
  45. keyword whole COMPILE yellow
  46. keyword whole CONNECT yellow
  47. keyword whole CONNECTION yellow
  48. keyword whole CONSTRAINT yellow
  49. keyword whole CONSTRAINTS yellow
  50. keyword whole CONTINUE yellow
  51. keyword whole COPY yellow
  52. keyword whole CORRESPONDING yellow
  53. keyword whole CREATE yellow
  54. keyword whole CROSS yellow
  55. keyword whole CURRENT yellow
  56. keyword whole CURRENT_DATE yellow
  57. keyword whole CURRENT_TIME yellow
  58. keyword whole CURRENT_TIMESTAMP yellow
  59. keyword whole CURRENT_USER yellow
  60. keyword whole CURSOR yellow
  61. keyword whole Constraint yellow
  62. keyword whole DATABASE yellow
  63. keyword whole DATE yellow
  64. keyword whole DATETIME yellow
  65. keyword whole DAY yellow
  66. keyword whole DEALLOCATE yellow
  67. keyword whole DEC yellow
  68. keyword whole DECIMAL yellow
  69. keyword whole DECLARE yellow
  70. keyword whole DEFAULT yellow
  71. keyword whole DEFERRABLE yellow
  72. keyword whole DEFERRED yellow
  73. keyword whole DELETE yellow
  74. keyword whole DESC yellow
  75. keyword whole DESCRIBE yellow
  76. keyword whole DESCRIPTOR yellow
  77. keyword whole DIAGNOSTICS yellow
  78. keyword whole DISCONNECT yellow
  79. keyword whole DISTINCT yellow
  80. keyword whole DOMAIN yellow
  81. keyword whole DOUBLE yellow
  82. keyword whole DROP yellow
  83. keyword whole ELSE yellow
  84. keyword whole ENCODING yellow
  85. keyword whole END yellow
  86. keyword whole END-EXEC yellow
  87. keyword whole ENUM yellow
  88. keyword whole ESCAPE yellow
  89. keyword whole EXCEPT yellow
  90. keyword whole EXCEPTION yellow
  91. keyword whole EXEC yellow
  92. keyword whole EXECUTE yellow
  93. keyword whole EXISTS yellow
  94. keyword whole EXTERNAL yellow
  95. keyword whole EXTRACT yellow
  96. keyword whole FALSE yellow
  97. keyword whole FETCH yellow
  98. keyword whole FIRST yellow
  99. keyword whole FLOAT yellow
  100. keyword whole FOR yellow
  101. keyword whole FOREIGN yellow
  102. keyword whole FORTRAN yellow
  103. keyword whole FOUND yellow
  104. keyword whole FROM yellow
  105. keyword whole FULL yellow
  106. keyword whole GET yellow
  107. keyword whole GLOBAL yellow
  108. keyword whole GO yellow
  109. keyword whole GOTO yellow
  110. keyword whole GRANT yellow
  111. keyword whole GROUP yellow
  112. keyword whole HAVING yellow
  113. keyword whole HOUR yellow
  114. keyword whole IDENTITY yellow
  115. keyword whole IF yellow
  116. keyword whole IMMEDIATE yellow
  117. keyword whole IN yellow
  118. keyword whole INCLUDE yellow
  119. keyword whole INDEX yellow
  120. keyword whole INDICATOR yellow
  121. keyword whole INITIALLY yellow
  122. keyword whole INNER yellow
  123. keyword whole INPUT yellow
  124. keyword whole INSENSITIVE yellow
  125. keyword whole INSERT yellow
  126. keyword whole INT yellow
  127. keyword whole INTEGER yellow
  128. keyword whole INTERSECT yellow
  129. keyword whole INTERVAL yellow
  130. keyword whole INTO yellow
  131. keyword whole IS yellow
  132. keyword whole ISOLATION yellow
  133. keyword whole JOIN yellow
  134. keyword whole KEY yellow
  135. keyword whole Key yellow
  136. keyword whole LANGUAGE yellow
  137. keyword whole LAST yellow
  138. keyword whole LEADING yellow
  139. keyword whole MERGE yellow
  140. keyword whole MINUS yellow
  141. keyword whole LEFT yellow
  142. keyword whole LEVEL yellow
  143. keyword whole LIKE yellow
  144. keyword whole LOCAL yellow
  145. keyword whole LOCK yellow
  146. keyword whole LONGBLOB yellow
  147. keyword whole LONGTEXT yellow
  148. keyword whole LOOP yellow
  149. keyword whole MATCH yellow
  150. keyword whole MEDIUMBLOB yellow
  151. keyword whole MEDIUMINT yellow
  152. keyword whole MEDIUMTEXT yellow
  153. keyword whole MINUTE yellow
  154. keyword whole MODULE yellow
  155. keyword whole MONTH yellow
  156. keyword whole NAMES yellow
  157. keyword whole NATIONAL yellow
  158. keyword whole NATURAL yellow
  159. keyword whole NCHAR yellow
  160. keyword whole NEXT yellow
  161. keyword whole NO yellow
  162. keyword whole NONE yellow
  163. keyword whole NOT yellow
  164. keyword whole NULL yellow
  165. keyword whole NULLIF yellow
  166. keyword whole NUMERIC yellow
  167. keyword whole OCTET_LENGTH yellow
  168. keyword whole OF yellow
  169. keyword whole OFFLINE yellow
  170. keyword whole ON yellow
  171. keyword whole ONLINE yellow
  172. keyword whole ONLY yellow
  173. keyword whole OPEN yellow
  174. keyword whole OPTION yellow
  175. keyword whole OR yellow
  176. keyword whole ORDER yellow
  177. keyword whole OUTER yellow
  178. keyword whole OUTPUT yellow
  179. keyword whole OVERLAPS yellow
  180. keyword whole PAD yellow
  181. keyword whole PARTIAL yellow
  182. keyword whole PASCAL yellow
  183. keyword whole POSITION yellow
  184. keyword whole PRECISION yellow
  185. keyword whole PREPARE yellow
  186. keyword whole PRESERVE yellow
  187. keyword whole PRIMARY yellow
  188. keyword whole PRIOR yellow
  189. keyword whole PRIVILEGES yellow
  190. keyword whole PROCEDURE yellow
  191. keyword whole PUBLIC yellow
  192. keyword whole Primary yellow
  193. keyword whole READ yellow
  194. keyword whole REAL yellow
  195. keyword whole REBUILD yellow
  196. keyword whole REFERENCES yellow
  197. keyword whole RELATIVE yellow
  198. keyword whole REPLACE yellow
  199. keyword whole RESTRICT yellow
  200. keyword whole REVOKE yellow
  201. keyword whole RIGHT yellow
  202. keyword whole ROLLBACK yellow
  203. keyword whole ROWS yellow
  204. keyword whole SCHEMA yellow
  205. keyword whole SCROLL yellow
  206. keyword whole SECOND yellow
  207. keyword whole SECTION yellow
  208. keyword whole SELECT yellow
  209. keyword whole SEQUENCE yellow
  210. keyword whole SESSION yellow
  211. keyword whole SESSION_USER yellow
  212. keyword whole SET yellow
  213. keyword whole SIZE yellow
  214. keyword whole SMALLINT yellow
  215. keyword whole SOME yellow
  216. keyword whole SPACE yellow
  217. keyword whole SQL yellow
  218. keyword whole SQLCA yellow
  219. keyword whole SQLSTATE yellow
  220. keyword whole SQLWARNING yellow
  221. keyword whole SUBSTRING yellow
  222. keyword whole SYSTEM_USER yellow
  223. keyword whole TRUNCATE 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 TIMESTAMP yellow
  232. keyword whole TIMEZONE_HOUR yellow
  233. keyword whole TIMEZONE_MINUTE yellow
  234. keyword whole TINYBLOB yellow
  235. keyword whole TINYINT yellow
  236. keyword whole TINYTEXT yellow
  237. keyword whole TO yellow
  238. keyword whole TRAILING yellow
  239. keyword whole TRANSACTION yellow
  240. keyword whole TRANSLATION yellow
  241. keyword whole TRIGGER yellow
  242. keyword whole TRIM yellow
  243. keyword whole TRUE yellow
  244. keyword whole TYPE yellow
  245. keyword whole UNION yellow
  246. keyword whole UNIQUE yellow
  247. keyword whole UNKNOWN yellow
  248. keyword whole UNSIGNED yellow
  249. keyword whole UPDATE yellow
  250. keyword whole USAGE yellow
  251. keyword whole USE yellow
  252. keyword whole USER yellow
  253. keyword whole USING yellow
  254. keyword whole VALUE yellow
  255. keyword whole VALUES yellow
  256. keyword whole VARCHAR yellow
  257. keyword whole VARYING yellow
  258. keyword whole VIEW yellow
  259. keyword whole WHEN yellow
  260. keyword whole WHENEVER yellow
  261. keyword whole WHERE yellow
  262. keyword whole WHILE yellow
  263. keyword whole WITH yellow
  264. keyword whole WORK yellow
  265. keyword whole WRITE yellow
  266. keyword whole YEAR yellow
  267. keyword whole ZONE yellow
  268. keyword whole abort yellow
  269. keyword whole absolute yellow
  270. keyword whole action yellow
  271. keyword whole ada yellow
  272. keyword whole add yellow
  273. keyword whole all yellow
  274. keyword whole allocate yellow
  275. keyword whole alter yellow
  276. keyword whole and yellow
  277. keyword whole any yellow
  278. keyword whole are yellow
  279. keyword whole as yellow
  280. keyword whole asc yellow
  281. keyword whole assertion yellow
  282. keyword whole at yellow
  283. keyword whole authorization yellow
  284. keyword whole auto_increment yellow
  285. keyword whole begin yellow
  286. keyword whole between yellow
  287. keyword whole bigint yellow
  288. keyword whole bit yellow
  289. keyword whole bit_length yellow
  290. keyword whole blob yellow
  291. keyword whole both yellow
  292. keyword whole by yellow
  293. keyword whole cascade yellow
  294. keyword whole cascaded yellow
  295. keyword whole case yellow
  296. keyword whole cast yellow
  297. keyword whole catalog yellow
  298. keyword whole char yellow
  299. keyword whole char_length yellow
  300. keyword whole character yellow
  301. keyword whole character_length yellow
  302. keyword whole check yellow
  303. keyword whole close yellow
  304. keyword whole coalesce yellow
  305. keyword whole collate yellow
  306. keyword whole collation yellow
  307. keyword whole column yellow
  308. keyword whole commit yellow
  309. keyword whole compile yellow
  310. keyword whole connect yellow
  311. keyword whole connection yellow
  312. keyword whole constraint yellow
  313. keyword whole constraint yellow
  314. keyword whole constraints yellow
  315. keyword whole continue yellow
  316. keyword whole copy yellow
  317. keyword whole corresponding yellow
  318. keyword whole create yellow
  319. keyword whole cross yellow
  320. keyword whole current yellow
  321. keyword whole current_date yellow
  322. keyword whole current_time yellow
  323. keyword whole current_timestamp yellow
  324. keyword whole current_user yellow
  325. keyword whole cursor yellow
  326. keyword whole database yellow
  327. keyword whole date yellow
  328. keyword whole datetime yellow
  329. keyword whole day yellow
  330. keyword whole deallocate yellow
  331. keyword whole dec yellow
  332. keyword whole decimal yellow
  333. keyword whole declare yellow
  334. keyword whole default yellow
  335. keyword whole deferrable yellow
  336. keyword whole deferred yellow
  337. keyword whole delete yellow
  338. keyword whole desc yellow
  339. keyword whole describe yellow
  340. keyword whole descriptor yellow
  341. keyword whole diagnostics yellow
  342. keyword whole disconnect yellow
  343. keyword whole distinct yellow
  344. keyword whole domain yellow
  345. keyword whole double yellow
  346. keyword whole drop yellow
  347. keyword whole else yellow
  348. keyword whole encoding yellow
  349. keyword whole end yellow
  350. keyword whole end-exec yellow
  351. keyword whole enum yellow
  352. keyword whole escape yellow
  353. keyword whole except yellow
  354. keyword whole exception yellow
  355. keyword whole exec yellow
  356. keyword whole execute yellow
  357. keyword whole exists yellow
  358. keyword whole external yellow
  359. keyword whole extract yellow
  360. keyword whole false yellow
  361. keyword whole fetch yellow
  362. keyword whole first yellow
  363. keyword whole float yellow
  364. keyword whole for yellow
  365. keyword whole foreign yellow
  366. keyword whole fortran yellow
  367. keyword whole found yellow
  368. keyword whole from yellow
  369. keyword whole full yellow
  370. keyword whole get yellow
  371. keyword whole global yellow
  372. keyword whole go yellow
  373. keyword whole goto yellow
  374. keyword whole grant yellow
  375. keyword whole group yellow
  376. keyword whole having yellow
  377. keyword whole hour yellow
  378. keyword whole identity yellow
  379. keyword whole if yellow
  380. keyword whole immediate yellow
  381. keyword whole in yellow
  382. keyword whole include yellow
  383. keyword whole index yellow
  384. keyword whole indicator yellow
  385. keyword whole initially yellow
  386. keyword whole inner yellow
  387. keyword whole input yellow
  388. keyword whole insensitive yellow
  389. keyword whole insert yellow
  390. keyword whole int yellow
  391. keyword whole integer yellow
  392. keyword whole intersect yellow
  393. keyword whole interval yellow
  394. keyword whole into yellow
  395. keyword whole is yellow
  396. keyword whole isolation yellow
  397. keyword whole join yellow
  398. keyword whole key yellow
  399. keyword whole key yellow
  400. keyword whole language yellow
  401. keyword whole last yellow
  402. keyword whole leading yellow
  403. keyword whole left yellow
  404. keyword whole level yellow
  405. keyword whole like yellow
  406. keyword whole local yellow
  407. keyword whole lock yellow
  408. keyword whole longblob yellow
  409. keyword whole longtext yellow
  410. keyword whole loop yellow
  411. keyword whole match yellow
  412. keyword whole mediumblob yellow
  413. keyword whole mediumint yellow
  414. keyword whole mediumtext yellow
  415. keyword whole merge yellow
  416. keyword whole minute yellow
  417. keyword whole minus yellow
  418. keyword whole module yellow
  419. keyword whole month yellow
  420. keyword whole names yellow
  421. keyword whole national yellow
  422. keyword whole natural yellow
  423. keyword whole nchar yellow
  424. keyword whole next yellow
  425. keyword whole no yellow
  426. keyword whole none yellow
  427. keyword whole not yellow
  428. keyword whole null yellow
  429. keyword whole nullif yellow
  430. keyword whole numeric yellow
  431. keyword whole octet_length yellow
  432. keyword whole of yellow
  433. keyword whole offline yellow
  434. keyword whole on yellow
  435. keyword whole online yellow
  436. keyword whole only yellow
  437. keyword whole open yellow
  438. keyword whole option yellow
  439. keyword whole or yellow
  440. keyword whole order yellow
  441. keyword whole outer yellow
  442. keyword whole output yellow
  443. keyword whole overlaps yellow
  444. keyword whole pad yellow
  445. keyword whole partial yellow
  446. keyword whole pascal yellow
  447. keyword whole position yellow
  448. keyword whole precision yellow
  449. keyword whole prepare yellow
  450. keyword whole preserve yellow
  451. keyword whole primary yellow
  452. keyword whole primary yellow
  453. keyword whole prior yellow
  454. keyword whole privileges yellow
  455. keyword whole procedure yellow
  456. keyword whole public yellow
  457. keyword whole read yellow
  458. keyword whole real yellow
  459. keyword whole rebuild yellow
  460. keyword whole references yellow
  461. keyword whole relative yellow
  462. keyword whole replace yellow
  463. keyword whole restrict yellow
  464. keyword whole revoke yellow
  465. keyword whole right yellow
  466. keyword whole rollback yellow
  467. keyword whole rows yellow
  468. keyword whole schema yellow
  469. keyword whole scroll yellow
  470. keyword whole second yellow
  471. keyword whole section yellow
  472. keyword whole select yellow
  473. keyword whole sequence yellow
  474. keyword whole session yellow
  475. keyword whole session_user yellow
  476. keyword whole set yellow
  477. keyword whole size yellow
  478. keyword whole smallint yellow
  479. keyword whole some yellow
  480. keyword whole space yellow
  481. keyword whole sql yellow
  482. keyword whole sqlca yellow
  483. keyword whole sqlstate yellow
  484. keyword whole sqlwarning yellow
  485. keyword whole substring yellow
  486. keyword whole system_user yellow
  487. keyword whole table yellow
  488. keyword whole tablespace yellow
  489. keyword whole template yellow
  490. keyword whole temporary yellow
  491. keyword whole text yellow
  492. keyword whole then yellow
  493. keyword whole time yellow
  494. keyword whole truncate yellow
  495. keyword whole timestamp yellow
  496. keyword whole timezone_hour yellow
  497. keyword whole timezone_minute yellow
  498. keyword whole tinyblob yellow
  499. keyword whole tinyint yellow
  500. keyword whole tinytext yellow
  501. keyword whole to yellow
  502. keyword whole trailing yellow
  503. keyword whole transaction yellow
  504. keyword whole translation yellow
  505. keyword whole trigger yellow
  506. keyword whole trim yellow
  507. keyword whole true yellow
  508. keyword whole type yellow
  509. keyword whole union yellow
  510. keyword whole unique yellow
  511. keyword whole unknown yellow
  512. keyword whole unsigned yellow
  513. keyword whole update yellow
  514. keyword whole usage yellow
  515. keyword whole use yellow
  516. keyword whole user yellow
  517. keyword whole using yellow
  518. keyword whole value yellow
  519. keyword whole values yellow
  520. keyword whole varchar yellow
  521. keyword whole varying yellow
  522. keyword whole view yellow
  523. keyword whole when yellow
  524. keyword whole whenever yellow
  525. keyword whole where yellow
  526. keyword whole while yellow
  527. keyword whole with yellow
  528. keyword whole work yellow
  529. keyword whole write yellow
  530. keyword whole year yellow
  531. keyword whole zone yellow
  532. keyword /\* brown
  533. keyword \*/ brown
  534. keyword -- brown
  535. keyword > brightcyan
  536. keyword < brightcyan
  537. keyword \+ brightcyan
  538. keyword - brightcyan
  539. keyword \* brightcyan
  540. keyword / brightcyan
  541. keyword % brightcyan
  542. keyword = brightcyan
  543. keyword ( brightcyan
  544. keyword ) brightcyan
  545. keyword , brightcyan
  546. keyword ; brightcyan
  547. keyword . white
  548. # PostgreSQL specific
  549. keyword AGGREGATE yellow
  550. keyword CHECKPOINT yellow
  551. keyword CLUSTER yellow
  552. keyword CONVERSION yellow
  553. keyword LISTEN yellow
  554. keyword NOTIFY yellow
  555. keyword OPERATOR yellow
  556. keyword REINDEX yellow
  557. keyword SAVEPOINT yellow
  558. keyword UNLISTEN yellow
  559. keyword VACUUM yellow
  560. keyword aggregate yellow
  561. keyword checkpoint yellow
  562. keyword cluster yellow
  563. keyword conversion yellow
  564. keyword listen yellow
  565. keyword notify yellow
  566. keyword operator yellow
  567. keyword reindex yellow
  568. keyword savepoint yellow
  569. keyword unlisten yellow
  570. keyword vacuum yellow
  571. keyword CREATEDB white
  572. keyword CREATEUSER white
  573. keyword NOCREATEDB white
  574. keyword NOCREATEUSER white
  575. keyword PASSWORD white
  576. keyword SYSID white
  577. keyword createdb white
  578. keyword createuser white
  579. keyword nocreatedb white
  580. keyword nocreateuser white
  581. keyword password white
  582. keyword sysid white
  583. keyword currval white
  584. keyword nextval white
  585. keyword pg_database white
  586. keyword pg_group white
  587. keyword pg_shadow white
  588. keyword setval white
  589. keyword stdin white
  590. # PostgreSQL sequences
  591. keyword cache white
  592. keyword increment white
  593. keyword maxvalue white
  594. keyword minvalue white
  595. keyword start white
  596. # MySQL comment
  597. context linestart # \n brown
  598. spellcheck
  599. # ANSI SQL comment
  600. context exclusive -- \n brown
  601. spellcheck
  602. context exclusive /\* \*/ brown
  603. spellcheck
  604. context ' ' green
  605. keyword \\' green
  606. context " " green
  607. keyword \\" green
  608. # Beckticks are used to escape reserved words in MySQL
  609. context ` ` cyan
  610. keyword . white