Schema documentation for component referential_triggered

Showing:

Diagrams

Instances

Model

Properties

Source

Used by

Element referential_triggered_action

Namespace

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

Diagram

Properties

content

complex

Used by

Element

references_specification

Model

update_delete_rule | delete_update_rule

Children

delete_update_rule, update_delete_rule

Instance

<referential_triggered_action xmlns="http://www.sqlparser.com/xml/ansi2003">
  <update_delete_rule>{1,1}</update_delete_rule>
  <delete_update_rule>{1,1}</delete_update_rule>
</referential_triggered_action>

Source

<xs:element name="referential_triggered_action">
  <xs:complexType>
    <xs:choice>
      <xs:element name="update_delete_rule">
        <xs:complexType>
          <xs:sequence>
            <xs:element ref="update_rule"/>
            <xs:element ref="delete_rule" minOccurs="0"/>
          </xs:sequence>
        </xs:complexType>
      </xs:element>
      <xs:element name="delete_update_rule">
        <xs:complexType>
          <xs:sequence>
            <xs:element ref="delete_rule"/>
            <xs:element ref="update_rule" minOccurs="0"/>
          </xs:sequence>
        </xs:complexType>
      </xs:element>
    </xs:choice>
  </xs:complexType>
</xs:element>

Element referential_triggered_action / update_delete_rule

Namespace

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

Diagram

Properties

content

complex

Model

update_rule , delete_rule{0,1}

Children

delete_rule, update_rule

Instance

<update_delete_rule xmlns="http://www.sqlparser.com/xml/ansi2003">
  <update_rule>{1,1}</update_rule>
  <delete_rule>{0,1}</delete_rule>
</update_delete_rule>

Source

<xs:element name="update_delete_rule">
  <xs:complexType>
    <xs:sequence>
      <xs:element ref="update_rule"/>
      <xs:element ref="delete_rule" minOccurs="0"/>
    </xs:sequence>
  </xs:complexType>
</xs:element>

Element referential_triggered_action / delete_update_rule

Namespace

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

Diagram

Properties

content

complex

Model

delete_rule , update_rule{0,1}

Children

delete_rule, update_rule

Instance

<delete_update_rule xmlns="http://www.sqlparser.com/xml/ansi2003">
  <delete_rule>{1,1}</delete_rule>
  <update_rule>{0,1}</update_rule>
</delete_update_rule>

Source

<xs:element name="delete_update_rule">
  <xs:complexType>
    <xs:sequence>
      <xs:element ref="delete_rule"/>
      <xs:element ref="update_rule" minOccurs="0"/>
    </xs:sequence>
  </xs:complexType>
</xs:element>