XML

I have an xml document containing a table definition. How can I use it to create a table in a 9.2.0.4 database?

Here's the contents of the file:

<?xml version="1.0" encoding="windows-1252" ?>
<?xml-stylesheet type="text/xsl" href="Table.xsl"?>

<!-- This is a generated file. Please do not alter. -->
<!-- Generated from SCIF. SCIF version = 1.1 Source Product =
PowerDesigner Source Product Version = 7.5.0.739 -->

<Table name='CT_REMINDER_TYPE' idMethod='none'>
<label>Reminder Type</label>
<Column name='RT_CODE' primaryKey='&lt;pk&gt;' datatype='varchar(16)'
nullable='false'>
<label>Reminder Type Code</label>
</Column>
<Column name='PROD_CODE' datatype='varchar(3)' nullable='false'>
<label>Product Code</label>
</Column>
<Column name='SYNC_GUID' datatype='guid' nullable='false'
defaultValue='SYS_GUID()'>
<label>Sync Guid</label>
</Column>
<Column name='LAST_MODIFIED' datatype='timestamp' nullable='false'
defaultValue='GET_UTC_DATETIME()'>
<label>Last Modified Timestamp</label>
</Column>
<Key name='PK_CT_REMINDER_TYPE' type='primary key'>
<key-column name='RT_CODE'/>
</Key>
<Foreign-key name='FK_CT_REMINDER_TYPE_PROD_CODE'
foreignTable='CT_PRODUCT'>
<reference local='PROD_CODE' foreign='PROD_CODE'/>
</Foreign-key>
<Index name='IDX_CT_REMINDER_TYPEUID' unique='true'>
<Index-column name='SYNC_GUID'/>
</Index>
</Table>
Received on Thu Sep 28 2006 - 09:52:56 CDT