Variable: sql-mode-sqlite-font-lock-keywords

sql-mode-sqlite-font-lock-keywords is a variable defined in sql.el.gz.

Value

(("^[.].*$" . font-lock-doc-face)
 ("\\b\\(a\\(?:bort\\|ction\\|dd\\|fter\\|l\\(?:l\\|ter\\)\\|n\\(?:alyze\\|d\\)\\|sc?\\|ttach\\|utoincrement\\)\\|b\\(?:e\\(?:fore\\|\\(?:gi\\|twee\\)n\\)\\|y\\)\\|c\\(?:as\\(?:cade\\|[et]\\)\\|heck\\|o\\(?:l\\(?:late\\|umn\\)\\|\\(?:mmi\\|n\\(?:flic\\|strain\\)\\)t\\)\\|r\\(?:eate\\|oss\\)\\)\\|d\\(?:atabase\\|e\\(?:f\\(?:ault\\|err\\(?:able\\|ed\\)\\)\\|lete\\|sc\\|tach\\)\\|istinct\\|rop\\)\\|e\\(?:ach\\|lse\\|nd\\|scape\\|x\\(?:c\\(?:ept\\|lusive\\)\\|ists\\|plain\\)\\)\\|f\\(?:ail\\|or\\(?:eign\\)?\\|rom\\|ull\\)\\|g\\(?:lob\\|roup\\)\\|having\\|i\\(?:gnore\\|mmediate\\|n\\(?:dex\\(?:ed\\)?\\|itially\\|ner\\|s\\(?:ert\\|tead\\)\\|t\\(?:ersect\\|o\\)\\)\\|snull\\|[fns]\\)\\|join\\|key\\|l\\(?:eft\\|i\\(?:ke\\|mit\\)\\)\\|match\\|n\\(?:atural\\|o\\(?:t\\(?:null\\)?\\)?\\|ull\\)\\|o\\(?:ffset\\|\\(?:rd\\|ut\\)er\\|[fnr]\\)\\|p\\(?:lan\\|r\\(?:agma\\|imary\\)\\)\\|query\\|r\\(?:aise\\|e\\(?:ferences\\|gexp\\|index\\|lease\\|name\\|place\\|strict\\)\\|ight\\|o\\(?:llback\\|w\\)\\)\\|s\\(?:\\(?:avepoin\\|e\\(?:lec\\)?\\)t\\)\\|t\\(?:able\\|emp\\(?:orary\\)?\\|hen\\|o\\|r\\(?:ansaction\\|igger\\)\\)\\|u\\(?:ni\\(?:on\\|que\\)\\|pdate\\|sing\\)\\|v\\(?:a\\(?:cuum\\|lues\\)\\|i\\(?:ew\\|rtual\\)\\)\\|whe\\(?:n\\|re\\)\\)\\b"
  . font-lock-keyword-face)
 ("\\b\\(b\\(?:ig\\(?:int\\)?\\|lob\\|oolean\\)\\|c\\(?:haracter\\|lob\\)\\|d\\(?:ate\\(?:time\\)?\\|ecimal\\|ouble\\)\\|float\\|int\\(?:eger\\|[28]\\)?\\|mediumint\\|n\\(?:ative\\|char\\|um\\(?:ber\\|eric\\)\\|varchar\\)\\|precision\\|real\\|smallint\\|t\\(?:\\(?:ex\\|inyin\\)t\\)\\|unsigned\\|var\\(?:char\\|ying\\)\\)\\b"
  . font-lock-type-face)
 ("\\b\\(a\\(?:bs\\|vg\\)\\|c\\(?:hanges\\|o\\(?:alesce\\|unt\\)\\|urrent_\\(?:date\\|time\\(?:stamp\\)?\\)\\)\\|g\\(?:lob\\|roup_concat\\)\\|hex\\|ifnull\\|julianday\\|l\\(?:ast_insert_rowid\\|ength\\|ike\\|o\\(?:ad_extension\\|wer\\)\\|trim\\)\\|m\\(?:ax\\|in\\)\\|nullif\\|quote\\|r\\(?:andom\\(?:blob\\)?\\|eplace\\|ound\\|trim\\)\\|s\\(?:oundex\\|qlite_\\(?:compileoption_\\(?:get\\|used\\)\\|source_id\\|version\\)\\|trftime\\|u\\(?:bstr\\|m\\)\\)\\|t\\(?:ime\\|otal\\(?:_changes\\)?\\|rim\\|ypeof\\)\\|upper\\|zeroblob\\)\\b"
  . font-lock-builtin-face))

Documentation

SQLite 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-sqlite-font-lock-keywords.

Source Code

;; Defined in /usr/src/emacs/lisp/progmodes/sql.el.gz
(defvar sql-mode-sqlite-font-lock-keywords
  (eval-when-compile
    (list
     ;; SQLite commands
     '("^[.].*$" . font-lock-doc-face)

     ;; SQLite Keyword
     (sql-font-lock-keywords-builder 'font-lock-keyword-face nil
"abort" "action" "add" "after" "all" "alter" "analyze" "and" "as"
"asc" "attach" "autoincrement" "before" "begin" "between" "by"
"cascade" "case" "cast" "check" "collate" "column" "commit" "conflict"
"constraint" "create" "cross" "database" "default" "deferrable"
"deferred" "delete" "desc" "detach" "distinct" "drop" "each" "else"
"end" "escape" "except" "exclusive" "exists" "explain" "fail" "for"
"foreign" "from" "full" "glob" "group" "having" "if" "ignore"
"immediate" "in" "index" "indexed" "initially" "inner" "insert"
"instead" "intersect" "into" "is" "isnull" "join" "key" "left" "like"
"limit" "match" "natural" "no" "not" "notnull" "null" "of" "offset"
"on" "or" "order" "outer" "plan" "pragma" "primary" "query" "raise"
"references" "regexp" "reindex" "release" "rename" "replace"
"restrict" "right" "rollback" "row" "savepoint" "select" "set" "table"
"temp" "temporary" "then" "to" "transaction" "trigger" "union"
"unique" "update" "using" "vacuum" "values" "view" "virtual" "when"
"where"
)
     ;; SQLite Data types
     (sql-font-lock-keywords-builder 'font-lock-type-face nil
"int" "integer" "tinyint" "smallint" "mediumint" "bigint" "unsigned"
"big" "int2" "int8" "character" "varchar" "varying" "nchar" "native"
"nvarchar" "text" "clob" "blob" "real" "double" "precision" "float"
"numeric" "number" "decimal" "boolean" "date" "datetime"
)
     ;; SQLite Functions
     (sql-font-lock-keywords-builder 'font-lock-builtin-face nil
;; Core functions
"abs" "changes" "coalesce" "glob" "ifnull" "hex" "last_insert_rowid"
"length" "like" "load_extension" "lower" "ltrim" "max" "min" "nullif"
"quote" "random" "randomblob" "replace" "round" "rtrim" "soundex"
"sqlite_compileoption_get" "sqlite_compileoption_used"
"sqlite_source_id" "sqlite_version" "substr" "total_changes" "trim"
"typeof" "upper" "zeroblob"
;; Date/time functions
"time" "julianday" "strftime"
"current_date" "current_time" "current_timestamp"
;; Aggregate functions
"avg" "count" "group_concat" "max" "min" "sum" "total"
)))

  "SQLite 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-sqlite-font-lock-keywords'.")