Execute the set_columnsXML stored procedure

This stored procedure will list information about the column (or field) within the specified database (or qualifier), and table. The Microsoft SQL wildcard character % may be used to specify any of the input arguments. The output is in XML format.

Note: The specification of wildcard inputs to this call may return a massive stream of XML. Use with caution.

ODBC Syntax

call sp_columnsXML(<database>,<table>,<column>)

Example

call sp_columnsXML('RTDB', 'message', '%');

<?xml version="1.0" standalone="no"?>

<SQLEngineDatastoreSchema>

<database name="RTDB" owner="dbo">

<table name="message" owner="dbo" description="Message text and color"

allowUpdate="yes" allowSelect="yes" allowDelete="yes" allowInsert="yes" tablelast=""

modified="10/10/2013 10:01:27.731" permissionslastmodified="10/10/2013

10:01:27.731">

<column name="name" owner="dbo" description="Message key

name" datatype="string" length="31" casesensitive="no" defaultvalue="yes"

nullable="no" precision="31" radix="" scale="" scope="" pseudocolumn=""

columntype="rowid"/>

<column name="setName" owner="dbo" description="Message

Set name" datatype="string" length="31" casesensitive="no" defaultvalue="yes"

nullable="no" precision="31" radix="" scale="" scope="" pseudocolumn=""

columntype="regular"/>...

<index name="" owner="dbo" column="" unique="unknown"

indextype="statistics" sequence="1" collation="" cardinality="129" pages=""

filtercondition=""/>

<index name="name" owner="dbo" column="name"

unique="yes" indextype="hashed" sequence="1" collation="ascending" cardinality="129"

pages="" filtercondition=""/>...

<key primarykey="" primarydatabase="RTDB"

primaryowner="dbo" primarytable="message" primarycolumn="name" sequence="1"

foreignkey="" foreigndatabase="" foreignowner="" foreigntable="" foreigncolumn=""

updaterule="" deleterule=""/>

<key primarykey="" primarydatabase="EnumDB"

primaryowner="dbo" primarytable="pntcolor" primarycolumn="edescr" sequence="1"

foreignkey="" foreigndatabase="RTDB" foreignowner="dbo" foreigntable="message"

foreigncolumn="fg" updaterule="" deleterule=""/>...

</table>

</database></SQLEngineDatastoreSchema>