Sp_PKeysXML

The sp_PKeysXML procedure lists the primary keys of the table within a database. You can use the Microsoft SQL wildcard character "%" in place of the table and/or key name.

Syntax

sp_PKeysXML(‘<database>’,’<table>’,’<key>’)

Example

call sp_PKeysXML(‘db’,’message’,’%’);

Output

Lists the primary keys of the Message table.

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

<OASyS DNASQLEngineSchema>

<database name="RTDB">

<table name="message" description="Message text and color" allowUpdate="yes" allowSelect="yes" allowDelete="yes" allowInsert="yes">

<index name="name" column="name" isunique="yes" type="other" sequence="1" collation="ascending" cardinality="" />

<index name="setName" column="setName" isunique="no" type="other" sequence="1" collation="ascending" cardinality="" />

</table>

</database>

</OASyS DNASQLEngineSchema>