2.1.2 ST_CommandType

Specifies how to use the CommandText element, as defined in the CT_Connection complex type (section 2.2.1), to obtain data from a data connection (1).

The following table specifies the enumeration values for this type.

Enumeration value	Meaning
Table	Specifies that the CommandText element specifies the name of a table that can be read from the data connection (1) to the data source, which is specified by the ConnectionString element.
SQL	Specifies that the CommandText element specifies text that can be interpreted, as an SQL query, by the data connection (1) to the data source, specified by the ConnectionString element.
Cube	Specifies that the CommandText element specifies the name of a cube within an OLAP database.
List	Specifies that the CommandText element specifies the XML of a list.
Default	Specifies that the CommandText element specifies text that will be interpreted by the data connection (1) to the data source, specified by the ConnectionString element. The text will be passed by the data connection (1) to the data source without change.
TableCollection<2>	Specifies that the CommandText element specifies the list of table names that can be read from the data connection (1) to the data source, which is specified by the ConnectionString element. The table names in the list MUST be separated by commas. Each table name in the list MUST be enclosed in quotes.

The following table lists all other types that reference this type.

Referenced by
CT_Connection

The following XML schema fragment defines this element.

 <xs:schema
   targetNamespace="urn:schemas-microsoft-com:office:odc"
   elementFormDefault="qualified"
   xmlns="urn:schemas-microsoft-com:office:odc"
   xmlns:xs="http://www.w3.org/2001/XMLSchema">
  
   <xs:simpleType name="ST_CommandType">
     <xs:restriction base="xs:string">
       <xs:enumeration value="Table" />
       <xs:enumeration value="SQL" />
       <xs:enumeration value="Cube" />
       <xs:enumeration value="List" />
       <xs:enumeration value="Default" />
       <xs:enumeration value="TableCollection" />
     </xs:restriction>
   </xs:simpleType>
  
 </xs:schema>