SQLTypeType simpleType

Specifies the SQL data type of a query parameter or PivotTable field.

Type Information

Namespace urn:schemas-microsoft-com:office:excel
Schema name XML Spreadsheet 2000

Definition

      
<xsd:simpleType name="SQLTypeType" >
  <xsd:restriction base="xsd:string">
    <xsd:enumeration value="BigInteger" />
    <xsd:enumeration value="Binary" />
    <xsd:enumeration value="Bit" />
    <xsd:enumeration value="Character" />
    <xsd:enumeration value="Date" />
    <xsd:enumeration value="Decimal" />
    <xsd:enumeration value="Double" />
    <xsd:enumeration value="Float" />
    <xsd:enumeration value="GUID" />
    <xsd:enumeration value="Integer" />
    <xsd:enumeration value="LongVariableBinary" />
    <xsd:enumeration value="LongVariableCharacter" />
    <xsd:enumeration value="Numeric" />
    <xsd:enumeration value="Real" />
    <xsd:enumeration value="SignedBigInteger" />
    <xsd:enumeration value="SignedInteger" />
    <xsd:enumeration value="SignedSmallInteger" />
    <xsd:enumeration value="SignedTinyInteger" />
    <xsd:enumeration value="SmallInteger" />
    <xsd:enumeration value="Time" />
    <xsd:enumeration value="TimeStamp" />
    <xsd:enumeration value="TinyInteger" />
    <xsd:enumeration value="Unknown" />
    <xsd:enumeration value="UnsignedBigInteger" />
    <xsd:enumeration value="UnsignedInteger" />
    <xsd:enumeration value="UnsignedSmallInteger" />
    <xsd:enumeration value="UnsignedTinyInteger" />
    <xsd:enumeration value="VariableBinary" />
    <xsd:enumeration value="VariableCharacter" />
    <xsd:enumeration value="WideCharacter" />
    <xsd:enumeration value="WideLongVariableCharacter" />
    <xsd:enumeration value="WideVariableCharacter" />
  </xsd:restriction>
</xsd:simpleType>


    
©2003-2004 Microsoft Corporation. All rights reserved. Permission to copy, display and distribute this document is available at: http://msdn.microsoft.com/library/en-us/odcXMLRef/html/odcXMLRefLegalNotice.asp