sp_fkeysXML

This stored procedure will list information about the foreign keys of a table within a database. 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_fkeysXML(<database>,<table>, <key>)

call sp_fkeysXML('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">

<key primarykey="" primarydatabase="RTDB" primaryowner="d bo" primarytable="message" primarycolumn="name" sequence="1" foreignk ey="" foreigndatabase="" foreignowner="" foreigntable="" foreigncolum n="" updaterule=""deleterule=""/>

<key primarykey="" primarydatabase="EnumDB" primaryowner= "dbo" primarytable="pntcolor" primarycolumn="edescr" sequence="1" for eignkey="" foreigndatabase="RTDB" foreignowner="dbo" foreigntable="me ssage" foreigncolumn="fg"updaterule="" deleterule=""/>

<key primarykey="" primarydatabase="EnumDB" primaryowner= "dbo" primarytable="sev_enum" primarycolumn="edescr" sequence="1" for eignkey="" foreigndatabase="RTDB" foreignowner="dbo" foreigntable="me ssage"foreigncolumn="severity" updaterule="" deleterule=""/>

</table>

</database>

</SQLEngineDatastoreSchema>