Schema documentation for component triggered

Showing:

Diagrams

Instances

Model

Properties

Source

Used by

Element triggered_action

Namespace

http://www.sqlparser.com/xml/ansi2003

Diagram

Properties

content

complex

Used by

Element

trigger_definition

Model

for_each_row_statement{0,1} , when_search_condition{0,1} , triggered_sql_statement

Children

for_each_row_statement, triggered_sql_statement, when_search_condition

Instance

<triggered_action xmlns="http://www.sqlparser.com/xml/ansi2003">
  <for_each_row_statement>{0,1}</for_each_row_statement>
  <when_search_condition>{0,1}</when_search_condition>
  <triggered_sql_statement>{1,1}</triggered_sql_statement>
</triggered_action>

Source

<xs:element name="triggered_action">
  <xs:complexType>
    <xs:sequence>
      <xs:element name="for_each_row_statement" minOccurs="0">
        <xs:complexType>
          <xs:sequence>
            <xs:element ref="kw_for"/>
            <xs:element ref="kw_each"/>
            <xs:element name="row_or_statement">
              <xs:complexType>
                <xs:choice>
                  <xs:element ref="kw_row"/>
                  <xs:element ref="kw_statement"/>
                </xs:choice>
              </xs:complexType>
            </xs:element>
          </xs:sequence>
        </xs:complexType>
      </xs:element>
      <xs:element name="when_search_condition" minOccurs="0">
        <xs:complexType>
          <xs:sequence>
            <xs:element ref="kw_when"/>
            <xs:element ref="search_condition"/>
          </xs:sequence>
        </xs:complexType>
      </xs:element>
      <xs:element ref="triggered_sql_statement"/>
    </xs:sequence>
  </xs:complexType>
</xs:element>

Element triggered_action / for_each_row_statement

Namespace

http://www.sqlparser.com/xml/ansi2003

Diagram

Properties

content	complex
minOccurs	0

Model

kw_for , kw_each , row_or_statement

Children

kw_each, kw_for, row_or_statement

Instance

<for_each_row_statement xmlns="http://www.sqlparser.com/xml/ansi2003">
  <kw_for>{1,1}</kw_for>
  <kw_each>{1,1}</kw_each>
  <row_or_statement>{1,1}</row_or_statement>
</for_each_row_statement>

Source

<xs:element name="for_each_row_statement" minOccurs="0">
  <xs:complexType>
    <xs:sequence>
      <xs:element ref="kw_for"/>
      <xs:element ref="kw_each"/>
      <xs:element name="row_or_statement">
        <xs:complexType>
          <xs:choice>
            <xs:element ref="kw_row"/>
            <xs:element ref="kw_statement"/>
          </xs:choice>
        </xs:complexType>
      </xs:element>
    </xs:sequence>
  </xs:complexType>
</xs:element>

Element triggered_action / for_each_row_statement / row_or_statement

Namespace

http://www.sqlparser.com/xml/ansi2003

Diagram

Properties

content

complex

Model

kw_row | kw_statement

Children

kw_row, kw_statement

Instance

<row_or_statement xmlns="http://www.sqlparser.com/xml/ansi2003">
  <kw_row>{1,1}</kw_row>
  <kw_statement>{1,1}</kw_statement>
</row_or_statement>

Source

<xs:element name="row_or_statement">
  <xs:complexType>
    <xs:choice>
      <xs:element ref="kw_row"/>
      <xs:element ref="kw_statement"/>
    </xs:choice>
  </xs:complexType>
</xs:element>

Element triggered_action / when_search_condition

Namespace

http://www.sqlparser.com/xml/ansi2003

Diagram

Properties

content	complex
minOccurs	0

Model

kw_when , search_condition

Children

kw_when, search_condition

Instance

<when_search_condition xmlns="http://www.sqlparser.com/xml/ansi2003">
  <kw_when>{1,1}</kw_when>
  <search_condition>{1,1}</search_condition>
</when_search_condition>

Source

<xs:element name="when_search_condition" minOccurs="0">
  <xs:complexType>
    <xs:sequence>
      <xs:element ref="kw_when"/>
      <xs:element ref="search_condition"/>
    </xs:sequence>
  </xs:complexType>
</xs:element>