Schema documentation for component identity_column

Showing:

Diagrams

Instances

Model

Properties

Source

Used by

Element identity_column_specification

Namespace

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

Diagram

Properties

content

complex

Used by

Element

column_definition/default_clause_identity_column_specification_generation_clause

Model

kw_generated , always_by_default , kw_as , kw_identity , common_sequence_generator_options{0,1}

Children

always_by_default, common_sequence_generator_options, kw_as, kw_generated, kw_identity

Instance

<identity_column_specification xmlns="http://www.sqlparser.com/xml/ansi2003">
  <kw_generated>{1,1}</kw_generated>
  <always_by_default>{1,1}</always_by_default>
  <kw_as>{1,1}</kw_as>
  <kw_identity>{1,1}</kw_identity>
  <common_sequence_generator_options>{0,1}</common_sequence_generator_options>
</identity_column_specification>

Source

<xs:element name="identity_column_specification">
  <xs:complexType>
    <xs:sequence>
      <xs:element ref="kw_generated"/>
      <xs:element name="always_by_default">
        <xs:complexType>
          <xs:choice>
            <xs:element ref="kw_always"/>
            <xs:element name="by_default">
              <xs:complexType>
                <xs:sequence>
                  <xs:element ref="kw_by"/>
                  <xs:element ref="kw_default"/>
                </xs:sequence>
              </xs:complexType>
            </xs:element>
          </xs:choice>
        </xs:complexType>
      </xs:element>
      <xs:element ref="kw_as"/>
      <xs:element ref="kw_identity"/>
      <xs:element ref="common_sequence_generator_options" minOccurs="0"/>
    </xs:sequence>
  </xs:complexType>
</xs:element>

Element identity_column_specification / always_by_default

Namespace

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

Diagram

Properties

content

complex

Model

kw_always | by_default

Children

by_default, kw_always

Instance

<always_by_default xmlns="http://www.sqlparser.com/xml/ansi2003">
  <kw_always>{1,1}</kw_always>
  <by_default>{1,1}</by_default>
</always_by_default>

Source

<xs:element name="always_by_default">
  <xs:complexType>
    <xs:choice>
      <xs:element ref="kw_always"/>
      <xs:element name="by_default">
        <xs:complexType>
          <xs:sequence>
            <xs:element ref="kw_by"/>
            <xs:element ref="kw_default"/>
          </xs:sequence>
        </xs:complexType>
      </xs:element>
    </xs:choice>
  </xs:complexType>
</xs:element>

Element identity_column_specification / always_by_default / by_default

Namespace

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

Diagram

Properties

content

complex

Model

kw_by , kw_default

Children

kw_by, kw_default

Instance

<by_default xmlns="http://www.sqlparser.com/xml/ansi2003">
  <kw_by>{1,1}</kw_by>
  <kw_default>{1,1}</kw_default>
</by_default>

Source

<xs:element name="by_default">
  <xs:complexType>
    <xs:sequence>
      <xs:element ref="kw_by"/>
      <xs:element ref="kw_default"/>
    </xs:sequence>
  </xs:complexType>
</xs:element>