Schema documentation for component merge

Showing:

Diagrams

Instances

Model

Properties

Source

Used by

Element merge_statement

Namespace

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

Diagram

Properties

content

complex

Used by

Elements	direct_sql_data_statement, preparable_sql_data_statement, sql_data_change_statement
Element Group	data_manipulation

Model

kw_merge , kw_into , target_table , as_merge_correlation_name{0,1} , kw_using , table_reference , kw_on , search_condition , merge_operation_specification

Children

as_merge_correlation_name, kw_into, kw_merge, kw_on, kw_using, merge_operation_specification, search_condition, table_reference, target_table

Instance

<merge_statement xmlns="http://www.sqlparser.com/xml/ansi2003">
  <kw_merge>{1,1}</kw_merge>
  <kw_into>{1,1}</kw_into>
  <target_table>{1,1}</target_table>
  <as_merge_correlation_name>{0,1}</as_merge_correlation_name>
  <kw_using>{1,1}</kw_using>
  <table_reference>{1,1}</table_reference>
  <kw_on>{1,1}</kw_on>
  <search_condition>{1,1}</search_condition>
  <merge_operation_specification>{1,1}</merge_operation_specification>
</merge_statement>

Source

<xs:element name="merge_statement">
  <xs:complexType>
    <xs:sequence>
      <xs:element ref="kw_merge"/>
      <xs:element ref="kw_into"/>
      <xs:element ref="target_table"/>
      <xs:element ref="as_merge_correlation_name" minOccurs="0"/>
      <xs:element ref="kw_using"/>
      <xs:element ref="table_reference"/>
      <xs:element ref="kw_on"/>
      <xs:element ref="search_condition"/>
      <xs:element ref="merge_operation_specification"/>
    </xs:sequence>
  </xs:complexType>
</xs:element>