Try OpenEdge Now
skip to main content
SQL Development
Preface : Examples of syntax diagrams (SQL) : Long SQL syntax descriptions split across lines
 

Long SQL syntax descriptions split across lines

Some syntax descriptions are too long to fit on one line. When syntax descriptions are split across multiple lines, groups of optional and groups of required items are kept together in the required order.
In this example, CREATE VIEW is followed by several optional items:

Syntax

CREATE VIEW [owner_name.]view_name
  [ ( column_name[, column_name]... ) ]
  AS [ ( ]query_expression[ ) ][ WITH CHECK OPTION ] ;