Schema documentation for component specific_routine

Showing:

Diagrams

Instances

Model

Properties

Source

Used by

Element specific_routine_designator

Namespace

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

Diagram

Properties

content

complex

Used by

Elements	alter_routine_statement, cast_function, drop_routine_statement, from_sql_function, map_function_specification, privelege_method_list, relative_function_specification, result_set_cursor, to_sql_function, transliteration_routine
Element Group	additional_common_elements

Model

routine_type_specific_name | routine_type_member_name

Children

routine_type_member_name, routine_type_specific_name

Instance

<specific_routine_designator xmlns="http://www.sqlparser.com/xml/ansi2003">
  <routine_type_specific_name>{1,1}</routine_type_specific_name>
  <routine_type_member_name>{1,1}</routine_type_member_name>
</specific_routine_designator>

Source

<xs:element name="specific_routine_designator">
  <xs:complexType>
    <xs:choice>
      <xs:element name="routine_type_specific_name">
        <xs:complexType>
          <xs:sequence>
            <xs:element ref="kw_specific"/>
            <xs:element ref="routine_type"/>
            <xs:element ref="specific_name"/>
          </xs:sequence>
        </xs:complexType>
      </xs:element>
      <xs:element name="routine_type_member_name">
        <xs:complexType>
          <xs:sequence>
            <xs:element ref="routine_type"/>
            <xs:element ref="member_name"/>
            <xs:element name="for_schema_resolved_user_defined_type_name" minOccurs="0">
              <xs:complexType>
                <xs:sequence>
                  <xs:element ref="kw_for"/>
                  <xs:element ref="schema_resolved_user_defined_type_name"/>
                </xs:sequence>
              </xs:complexType>
            </xs:element>
          </xs:sequence>
        </xs:complexType>
      </xs:element>
    </xs:choice>
  </xs:complexType>
</xs:element>

Element specific_routine_designator / routine_type_specific_name

Namespace

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

Diagram

Properties

content

complex

Model

kw_specific , routine_type , specific_name

Children

kw_specific, routine_type, specific_name

Instance

<routine_type_specific_name xmlns="http://www.sqlparser.com/xml/ansi2003">
  <kw_specific>{1,1}</kw_specific>
  <routine_type>{1,1}</routine_type>
  <specific_name>{1,1}</specific_name>
</routine_type_specific_name>

Source

<xs:element name="routine_type_specific_name">
  <xs:complexType>
    <xs:sequence>
      <xs:element ref="kw_specific"/>
      <xs:element ref="routine_type"/>
      <xs:element ref="specific_name"/>
    </xs:sequence>
  </xs:complexType>
</xs:element>

Element specific_routine_designator / routine_type_member_name

Namespace

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

Diagram

Properties

content

complex

Model

routine_type , member_name , for_schema_resolved_user_defined_type_name{0,1}

Children

for_schema_resolved_user_defined_type_name, member_name, routine_type

Instance

<routine_type_member_name xmlns="http://www.sqlparser.com/xml/ansi2003">
  <routine_type>{1,1}</routine_type>
  <member_name>{1,1}</member_name>
  <for_schema_resolved_user_defined_type_name>{0,1}</for_schema_resolved_user_defined_type_name>
</routine_type_member_name>

Source

<xs:element name="routine_type_member_name">
  <xs:complexType>
    <xs:sequence>
      <xs:element ref="routine_type"/>
      <xs:element ref="member_name"/>
      <xs:element name="for_schema_resolved_user_defined_type_name" minOccurs="0">
        <xs:complexType>
          <xs:sequence>
            <xs:element ref="kw_for"/>
            <xs:element ref="schema_resolved_user_defined_type_name"/>
          </xs:sequence>
        </xs:complexType>
      </xs:element>
    </xs:sequence>
  </xs:complexType>
</xs:element>

Element specific_routine_designator / routine_type_member_name / for_schema_resolved_user_defined_type_name

Namespace

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

Diagram

Properties

content	complex
minOccurs	0

Model

kw_for , schema_resolved_user_defined_type_name

Children

kw_for, schema_resolved_user_defined_type_name

Instance

<for_schema_resolved_user_defined_type_name xmlns="http://www.sqlparser.com/xml/ansi2003">
  <kw_for>{1,1}</kw_for>
  <schema_resolved_user_defined_type_name>{1,1}</schema_resolved_user_defined_type_name>
</for_schema_resolved_user_defined_type_name>

Source

<xs:element name="for_schema_resolved_user_defined_type_name" minOccurs="0">
  <xs:complexType>
    <xs:sequence>
      <xs:element ref="kw_for"/>
      <xs:element ref="schema_resolved_user_defined_type_name"/>
    </xs:sequence>
  </xs:complexType>
</xs:element>