Option: columnstyle=attribute

The format of a generated XML schema for columnstyle=attribute is similar to the XML schema for columnstyle=element. The only difference is that the columns are specified as XML attributes of the rowtype declaration. For example:

select forxmlschemaj("select 1,2", "columnstyle=attribute")
----------------------- 
<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema"
 xmlns:sqlxml="http://www.iso-standards.org/mra/9075/sqlx">

<xsd:import namespace="http://www.w3.org/2001/XMLSchema"
   schemaLocation="http://www.iso-standards.org/mra/9075/sqlx.xsd" />

   <xsd:complexType name="RowType.resultset">

      <xsd:attribute name="C1" type="INTEGER" use="required"/>
      <xsd:attribute name="C2" type="INTEGER" use="required"/>

  </xsd:complexType> 

   <xsd:complexType name="TableType.resultset">      
   <xsd:sequence>         
      <xsd:element name="row" type="RowType.resultset" 
          minOccurs="0" maxOccurs="unbounded"/>
      </xsd:sequence>
   </xsd:complexType>

   <xsd:simpleType name="INTEGER">
     <xsd:restriction base="xsd:integer">
        <xsd:maxInclusive value="2147483647"/>
         <xsd:minInclusive value="-2147483648"/>
     </xsd:restriction>
  </xsd:simpleType>

  <xsd:element name="resultset" type="TableType.resultset"/>

</xsd:schema>