- Index

< Previous |  | Next >

# LiveView Reserved Words

LiveView inherits the reserved word lists from StreamSQL and the StreamBase expression language, and also adds a few of its own. When you name fields and other identifiers in LiveView queries, do not use words from any of these lists.

StreamSQL Reserved Words

  The terms in the following list of are sorted alphabetically across, then down.

  advance | always | and | apply | as | asc | between | bsort
  by | constant | create | declare | default | delete | desc | duplicate
  error | every | except | extends | false | foreach | from | gather
  group | having | heartbeat | if | implements | import | index | input
  insert | into | join | key | limit | lock | lockset | materialized
  merge | metronome | not | null | offset | on | or | order
  outer | output | parallel | parameters | partition | pattern | predicate | primary
  private | public | replace | returning | schema | secondary | select | set
  size | slack | stream | table | then | time | timeout | true
  truncate | tuples | union | unlock | update | using | valid | vjoin
  where | window | with | within |  |  |  |

StreamBase Expression Language Reserved Words

  The StreamBase expression language has the following reserved words:

  and | as | between
  else | false | function
  if | or | not
  null | then | true

  Most of these reserved words duplicate words in the StreamSQL list. The following expression language reserved words are reserved in LiveView in addition to the StreamSQL reserved words:

  else | function

LiveView Additional Reserved Words

  LiveView has the following additional reserved words:

  command | for | key
  old | pivot | publisherid
  publishersn | values |

  Finally, no LiveView column name can begin with `CQS` or an underscore (`_`).