Execute the set_tablesXML stored procedure

This stored procedure will list information about all the tables within either the specified database (or qualifier) or all databases. Use the Microsoft SQL wildcard character % instead of a database name to specify all databases. The output is in XML format.

ODBC Syntax

call sp_tablesXML(<database>)

Example

call sp_tablesXML('RTDB');

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

<SQLEngineDatastoreSchema>

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

<table name="XIS_sync_trans" owner="dbo" description="XIS Synchronous Transaction

Queue" allowUpdate="yes" allowSelect="yes" allowDelete="yes" allowInsert="yes"

tablelastmodified="10/10/2013 10:01:28.839" permissionslastmodified="10/10/2013

10:01:28.839">

</table>

<table name="tag" owner="dbo" description="a device tag" allowUpdate="yes"

allowSelect="yes" allowDelete="yes" allowInsert="yes" tablelastmodified="10/10/2013

10:01:28.449" permissionslastmodified="10/10/2013 10:01:28.449">

</table>...

<table name="DevSpooler" owner="dbo" description="Device Spooler Sequence Table"

allowUpdate="yes" allowSelect="yes" all=""owDelete="yes" allowInsert="yes"

tablelastmodified="10/10/2013 10:01:28.839" permissionslastmodified="10/10/2013

10:01:28.839">

</table>

</database>

</SQLEngineDatastoreSchema>