Showing:

Diagrams
Instances
Model
Properties
Source
Used by
Element view_definition
Namespace http://www.sqlparser.com/xml/ansi2003
Diagram
Diagram ansi2003_xsd_Element_kw_create.tmp#kw_create ansi2003_xsd_Element_kw_recursive.tmp#kw_recursive ansi2003_xsd_Element_kw_view.tmp#kw_view ansi2003_xsd_Element_table_name.tmp#table_name ansi2003_xsd_Element_view_specification.tmp#view_specification ansi2003_xsd_Element_kw_as.tmp#kw_as ansi2003_xsd_Element_query_expression.tmp#query_expression ansi2003_xsd_Element_view_definition.tmp#view_definition_with_level_clause_check_option
Properties
content complex
Used by
Model
Children kw_as, kw_create, kw_recursive, kw_view, query_expression, table_name, view_specification, with_level_clause_check_option
Instance
<view_definition xmlns="http://www.sqlparser.com/xml/ansi2003">
  <kw_create>{1,1}</kw_create>
  <kw_recursive>{0,1}</kw_recursive>
  <kw_view>{1,1}</kw_view>
  <table_name>{1,1}</table_name>
  <view_specification>{1,1}</view_specification>
  <kw_as>{1,1}</kw_as>
  <query_expression>{1,1}</query_expression>
  <with_level_clause_check_option>{1,1}</with_level_clause_check_option>
</view_definition>
Source
<xs:element name="view_definition">
  <xs:complexType>
    <xs:sequence>
      <xs:element ref="kw_create"/>
      <xs:element ref="kw_recursive" minOccurs="0"/>
      <xs:element ref="kw_view"/>
      <xs:element ref="table_name"/>
      <xs:element ref="view_specification"/>
      <xs:element ref="kw_as"/>
      <xs:element ref="query_expression"/>
      <xs:element name="with_level_clause_check_option">
        <xs:complexType>
          <xs:sequence>
            <xs:element ref="kw_with"/>
            <xs:element ref="levels_clause" minOccurs="0"/>
            <xs:element ref="kw_check"/>
            <xs:element ref="kw_option"/>
          </xs:sequence>
        </xs:complexType>
      </xs:element>
    </xs:sequence>
  </xs:complexType>
</xs:element>
Element view_definition / with_level_clause_check_option
Namespace http://www.sqlparser.com/xml/ansi2003
Diagram
Diagram ansi2003_xsd_Element_kw_with.tmp#kw_with ansi2003_xsd_Element_levels_clause.tmp#levels_clause ansi2003_xsd_Element_kw_check.tmp#kw_check ansi2003_xsd_Element_kw_option.tmp#kw_option
Properties
content complex
Model
Children kw_check, kw_option, kw_with, levels_clause
Instance
<with_level_clause_check_option xmlns="http://www.sqlparser.com/xml/ansi2003">
  <kw_with>{1,1}</kw_with>
  <levels_clause>{0,1}</levels_clause>
  <kw_check>{1,1}</kw_check>
  <kw_option>{1,1}</kw_option>
</with_level_clause_check_option>
Source
<xs:element name="with_level_clause_check_option">
  <xs:complexType>
    <xs:sequence>
      <xs:element ref="kw_with"/>
      <xs:element ref="levels_clause" minOccurs="0"/>
      <xs:element ref="kw_check"/>
      <xs:element ref="kw_option"/>
    </xs:sequence>
  </xs:complexType>
</xs:element>