Schema documentation for component trigger

Showing:

Diagrams

Instances

Model

Properties

Source

Used by

Element trigger_definition

Namespace

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

Diagram

Properties

content

complex

Used by

Elements	schema_element, sql_schema_definition_statement
Element Group	schema_definition_and_manipulation

Model

kw_create , kw_trigger , trigger_name , trigger_action_time , trigger_event , kw_on , table_name , referencing_transition_table_or_variable_list , triggered_action

Children

kw_create, kw_on, kw_trigger, referencing_transition_table_or_variable_list, table_name, trigger_action_time, trigger_event, trigger_name, triggered_action

Instance

<trigger_definition xmlns="http://www.sqlparser.com/xml/ansi2003">
  <kw_create>{1,1}</kw_create>
  <kw_trigger>{1,1}</kw_trigger>
  <trigger_name>{1,1}</trigger_name>
  <trigger_action_time>{1,1}</trigger_action_time>
  <trigger_event>{1,1}</trigger_event>
  <kw_on>{1,1}</kw_on>
  <table_name>{1,1}</table_name>
  <referencing_transition_table_or_variable_list>{1,1}</referencing_transition_table_or_variable_list>
  <triggered_action>{1,1}</triggered_action>
</trigger_definition>

Source

<xs:element name="trigger_definition">
  <xs:complexType>
    <xs:sequence>
      <xs:element ref="kw_create"/>
      <xs:element ref="kw_trigger"/>
      <xs:element ref="trigger_name"/>
      <xs:element ref="trigger_action_time"/>
      <xs:element ref="trigger_event"/>
      <xs:element ref="kw_on"/>
      <xs:element ref="table_name"/>
      <xs:element name="referencing_transition_table_or_variable_list">
        <xs:complexType>
          <xs:sequence>
            <xs:element ref="kw_referencing"/>
            <xs:element ref="transition_table_or_variable_list"/>
          </xs:sequence>
        </xs:complexType>
      </xs:element>
      <xs:element ref="triggered_action"/>
    </xs:sequence>
  </xs:complexType>
</xs:element>

Element trigger_definition / referencing_transition_table_or_variable_list