Schema documentation for component update_statement

Showing:

Diagrams

Instances

Model

Properties

Source

Used by

Element update_statement_positioned

Namespace

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

Diagram

Properties

content

complex

Used by

Element	sql_data_change_statement
Element Group	data_manipulation

Model

kw_update , target_table , as_correlation_name{0,1} , kw_set , set_clause_list , kw_where , kw_current , kw_of , cursor_name

Children

as_correlation_name, cursor_name, kw_current, kw_of, kw_set, kw_update, kw_where, set_clause_list, target_table

Instance

<update_statement_positioned xmlns="http://www.sqlparser.com/xml/ansi2003">
  <kw_update>{1,1}</kw_update>
  <target_table>{1,1}</target_table>
  <as_correlation_name>{0,1}</as_correlation_name>
  <kw_set>{1,1}</kw_set>
  <set_clause_list>{1,1}</set_clause_list>
  <kw_where>{1,1}</kw_where>
  <kw_current>{1,1}</kw_current>
  <kw_of>{1,1}</kw_of>
  <cursor_name>{1,1}</cursor_name>
</update_statement_positioned>

Source

<xs:element name="update_statement_positioned">
  <xs:complexType>
    <xs:sequence>
      <xs:element ref="kw_update"/>
      <xs:element ref="target_table"/>
      <xs:element ref="as_correlation_name" minOccurs="0"/>
      <xs:element ref="kw_set"/>
      <xs:element ref="set_clause_list"/>
      <xs:element ref="kw_where"/>
      <xs:element ref="kw_current"/>
      <xs:element ref="kw_of"/>
      <xs:element ref="cursor_name"/>
    </xs:sequence>
  </xs:complexType>
</xs:element>