sql-mode-ansi-font-lock-keywords

sql-mode-ansi-font-lock-keywords is a variable defined in `sql.el'.
Its value is

(("\\b\\(a\\(?:da\\|s\\(?:ensitive\\|signment\\|ymmetric\\)\\|tomic\\)\\|b\\(?:etween\\|itvar\\)\\|c\\(?:a\\(?:lled\\|talog_name\\)\\|h\\(?:a\\(?:in\\|racter_set_\\(?:catalog\\|name\\|schema\\)\\)\\|ecked\\)\\|lass_origin\\|o\\(?:bol\\|l\\(?:lation_\\(?:catalog\\|name\\|schema\\)\\|umn_name\\)\\|mm\\(?:and_function\\(?:_code\\)?\\|itted\\)\\|n\\(?:dition_number\\|nection_name\\|straint_\\(?:catalog\\|name\\|schema\\)\\|tains\\)\\)\\|ursor_name\\)\\|d\\(?:atetime_interval_\\(?:code\\|precision\\)\\|efine[dr]\\|ispatch\\|ynamic_function\\(?:_code\\)?\\)\\|exist\\(?:ing\\|s\\)\\|f\\(?:inal\\|ortran\\)\\|g\\(?:\\(?:enera\\|ran\\)ted\\)\\|h\\(?:ierarchy\\|old\\)\\|i\\(?:mplementation\\|n\\(?:fix\\|s\\(?:\\(?:ensitiv\\|tan\\(?:c\\|tiabl\\)\\)e\\)\\|voker\\)\\)\\|key_\\(?:member\\|type\\)\\|length\\|m\\(?:e\\(?:ssage_\\(?:length\\|octet_length\\|text\\)\\|thod\\)\\|ore\\|umps\\)?\\|n\\(?:ame\\|u\\(?:llable\\|mber\\)\\)\\|o\\(?:ptions\\|ver\\(?:laps\\|riding\\)\\)\\|p\\(?:a\\(?:rameter_\\(?:mode\\|name\\|ordinal_position\\|specific_\\(?:catalog\\|name\\|schema\\)\\)\\|scal\\)\\|li\\|osition\\)\\|r\\(?:e\\(?:peatable\\|turned_\\(?:length\\|octet_length\\|sqlstate\\)\\)\\|o\\(?:utine_\\(?:catalog\\|name\\|schema\\)\\|w_count\\)\\)\\|s\\(?:c\\(?:\\(?:al\\|hema_nam\\)e\\)\\|e\\(?:curity\\|lf\\|\\(?:nsitiv\\|r\\(?:ializabl\\|ver_nam\\)\\)e\\)\\|im\\(?:ilar\\|ple\\)\\|ource\\|pecific_name\\|tyle\\|ub\\(?:class_origin\\|list\\)\\|y\\(?:mmetric\\|stem\\)\\)\\|t\\(?:able_name\\|r\\(?:ans\\(?:action\\(?:_active\\|s_\\(?:committed\\|rolled_back\\)\\)\\|forms?\\)\\|igger_\\(?:catalog\\|name\\|schema\\)\\)\\|ype\\)\\|u\\(?:n\\(?:\\(?:committ\\|nam\\)ed\\)\\|ser_defined_type_\\(?:catalog\\|name\\|schema\\)\\)\\)\\b" . font-lock-keyword-face) ("\\b\\(a\\(?:bsolute\\|ction\\|d\\(?:d\\|min\\)\\|fter\\|ggregate\\|l\\(?:ias\\|l\\(?:ocate\\)?\\|ter\\)\\|n[dy]\\|re\\|s\\(?:c\\|sertion\\)\\|uthorization\\|[st]\\)\\|b\\(?:e\\(?:fore\\|gin\\)\\|oth\\|readth\\|y\\)\\|c\\(?:a\\(?:ll\\|s\\(?:caded?\\|e\\)\\|talog\\)\\|heck\\|l\\(?:ass\\|ose\\)\\|o\\(?:l\\(?:lat\\(?:e\\|ion\\)\\|umn\\)\\|m\\(?:mit\\|pletion\\)\\|n\\(?:nect\\(?:ion\\)?\\|str\\(?:aints?\\|uctor\\)\\|tinue\\)\\|rresponding\\)\\|r\\(?:eate\\|oss\\)\\|u\\(?:be\\|r\\(?:rent\\|sor\\)\\)\\|ycle\\)\\|d\\(?:a\\(?:ta\\|y\\)\\|e\\(?:allocate\\|clare\\|f\\(?:ault\\|err\\(?:able\\|ed\\)\\)\\|lete\\|pth\\|ref\\|s\\(?:c\\(?:ri\\(?:be\\|ptor\\)\\)?\\|tr\\(?:oy\\|uctor\\)\\)\\|terministic\\)\\|i\\(?:agnostics\\|ctionary\\|s\\(?:\\(?:conne\\|tin\\)ct\\)\\)\\|omain\\|rop\\|ynamic\\)\\|e\\(?:ach\\|lse\\|nd\\|quals\\|scape\\|very\\|x\\(?:cept\\(?:ion\\)?\\|ec\\(?:ute\\)?\\|ternal\\)\\)\\|f\\(?:alse\\|etch\\|irst\\|o\\(?:r\\(?:eign\\)?\\|und\\)\\|r\\(?:ee\\|om\\)\\|u\\(?:ll\\|nction\\)\\)\\|g\\(?:e\\(?:neral\\|t\\)\\|lobal\\|o\\(?:to\\)?\\|r\\(?:ant\\|oup\\(?:ing\\)?\\)\\)\\|h\\(?:aving\\|o\\(?:st\\|ur\\)\\)\\|i\\(?:dentity\\|gnore\\|mmediate\\|n\\(?:dicator\\|itial\\(?:ize\\|ly\\)\\|ner\\|out\\|put\\|sert\\|t\\(?:ersect\\|o\\)\\)\\|solation\\|terate\\|[ns]\\)\\|join\\|key\\|l\\(?:a\\(?:nguage\\|st\\|teral\\)\\|e\\(?:ading\\|ft\\|ss\\|vel\\)\\|i\\(?:ke\\|mit\\)\\|oca\\(?:l\\|tor\\)\\)\\|m\\(?:a\\(?:p\\|tch\\)\\|inute\\|o\\(?:d\\(?:if\\(?:ies\\|y\\)\\|ule\\)\\|nth\\)\\)\\|n\\(?:a\\(?:mes\\|tural\\)\\|e\\(?:w\\|xt\\)\\|o\\(?:ne\\|t\\)?\\|ull\\)\\|o\\(?:ff\\|ld\\|nly\\|p\\(?:\\(?:e\\(?:ratio\\)?\\|tio\\)n\\)\\|rd\\(?:er\\|inality\\)\\|ut\\(?:er\\|put\\)?\\|[fnr]\\)\\|p\\(?:a\\(?:d\\|r\\(?:ameters?\\|tial\\)\\|th\\)\\|ostfix\\|r\\(?:e\\(?:fix\\|order\\|\\(?:par\\|serv\\)e\\)\\|i\\(?:mary\\|or\\|vileges\\)\\|ocedure\\)\\|ublic\\)\\|r\\(?:e\\(?:ads?\\|cursive\\|ferenc\\(?:es\\|ing\\)\\|lative\\|s\\(?:\\(?:tric\\|ul\\)t\\)\\|turns?\\|voke\\)\\|ight\\|o\\(?:l\\(?:e\\|l\\(?:back\\|up\\)\\)\\|utine\\|ws\\)\\)\\|s\\(?:avepoint\\|c\\(?:hema\\|roll\\)\\|e\\(?:arch\\|c\\(?:ond\\|tion\\)\\|lect\\|quence\\|ssion\\|ts?\\)\\|ize\\|ome\\|p\\(?:ace\\|ecific\\(?:type\\)?\\)\\|ql\\(?:exception\\|state\\|warning\\)?\\|t\\(?:a\\(?:rt\\|t\\(?:e\\(?:ment\\)?\\|ic\\)\\)\\|ructure\\)\\)\\|t\\(?:able\\|e\\(?:mporary\\|rminate\\)\\|h\\(?:[ae]n\\)\\|imezone_\\(?:hour\\|minute\\)\\|o\\|r\\(?:a\\(?:iling\\|ns\\(?:\\(?:ac\\|la\\)tion\\)\\)\\|igger\\|ue\\)\\)\\|u\\(?:n\\(?:der\\|i\\(?:on\\|que\\)\\|known\\|nest\\)\\|pdate\\|s\\(?:age\\|ing\\)\\)\\|v\\(?:a\\(?:lues?\\|riable\\)\\|iew\\)\\|w\\(?:he\\(?:n\\(?:ever\\)?\\|re\\)\\|ith\\(?:out\\)?\\|ork\\|rite\\)\\|year\\)\\b" . font-lock-keyword-face) ("\\b\\(a\\(?:bs\\|vg\\)\\|bit_length\\|c\\(?:a\\(?:rdinality\\|st\\)\\|har\\(?:\\(?:acter\\)?_length\\)\\|o\\(?:alesce\\|\\(?:nver\\|un\\)t\\)\\|urrent_\\(?:date\\|path\\|role\\|time\\(?:stamp\\)?\\|user\\)\\)\\|extract\\|lo\\(?:caltime\\(?:stamp\\)?\\|wer\\)\\|m\\(?:ax\\|in\\|od\\)\\|nullif\\|o\\(?:ctet_length\\|verlay\\)\\|placing\\|s\\(?:ession_user\\|u\\(?:bstring\\|m\\)\\|ystem_user\\)\\|tr\\(?:anslate\\|eat\\|im\\)\\|u\\(?:\\(?:pp\\|s\\)er\\)\\)\\b" . font-lock-builtin-face) ("\\b\\(array\\|b\\(?:i\\(?:nary\\|t\\)\\|lob\\|oolean\\)\\|c\\(?:har\\(?:acter\\)?\\|lob\\)\\|d\\(?:ate\\|ec\\(?:imal\\)?\\|ouble\\)\\|float\\|int\\(?:e\\(?:ger\\|rval\\)\\)?\\|large\\|n\\(?:ational\\|c\\(?:har\\|lob\\)\\|umeric\\)\\|object\\|precision\\|r\\(?:e\\(?:al\\|f\\)\\|ow\\)\\|s\\(?:cope\\|mallint\\)\\|time\\(?:stamp\\)?\\|var\\(?:char\\|ying\\)\\|zone\\)\\b" . font-lock-type-face))

  • This variable may be risky if used as a file-local variable.

Documentation:
ANSI SQL keywords used by font-lock.

This variable is used by `sql-mode' and `sql-interactive-mode'. The
regular expressions are created during compilation by calling the
function `regexp-opt'. Therefore, take a look at the source before
you define your own `sql-mode-ansi-font-lock-keywords'. You may want
to add functions and PL/SQL keywords.