sp_keysXML

This stored procedure will list information about the primary keys of a table within a database (or "qualifier"). The Microsoft SQL wildcard character % may be used to specify any of the input arguments. The output is in XML format. The specification of wildcard inputs to this call may return a massive stream of XML. Use with caution.

call sp_pkeysXML(<database>,<table>, <key>)

call sp_pkeysXML('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" tablelastmodified="10/10/2013 10:01:27.731" permissionslastmodified="10/10/2013 10:01:27.731">

<index name="" owner="dbo" column="" unique="unknown" ind extype="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=""/>

<index name="setName" owner="dbo" column="setName" unique="no" indextype="hashed" sequence="1" collation="ascending" cardinality="24" pages="" filtercondition=""/>

<index name="ptnum" owner="dbo" column="ptnum" unique="ye s" indextype="clustered" sequence="1" collation="ascending" cardinali ty="129" pagesfiltercondition=""/>

</table>

</database>

</SQLEngineDatastoreSchema>