Export (0) Print
Expand All

Sample Encoding

SQL Server 2000
<?xml version="1.0" ?> 
     <oim:Transfer xmlns:oim="http://www.mdcinfo.com/oim/oim.dtd" xmlns:dbm="http://www.mdcinfo.com/oim/dbm.dtd">
        <dbm:Catalog oim:id="_1" name="sales" comments="Sample catalog">
           <dbm:CatalogSchemas>
              <dbm:Schema oim:id="_2" name="dbo">
              <dbm:SchemaTables>
                 <dbm:Table oim:id="_3" name="Customer">
                    <dbm:ColumnSetColumns>
                       <dbm:Column oim:id="_6" name="CustomerID" IsNullable="0" /> 
                       <dbm:Column oim:id="_7" name="Name" IsNullable="0" /> 
                       <dbm:Column oim:id="_8" name="Address" IsNullable="1" /> 
                       <dbm:Column oim:id="_9" name="Phone" IsNullable="1" /> 
                    </dbm:ColumnSetColumns>
                 </dbm:Table>
                 <dbm:Table oim:id="_4" name="Order" EstimatedRows="10000">
                    <dbm:ColumnSetColumns>
                       <dbm:Column oim:id="_10" name="CustomerID" IsNullable="0" /> 
                       <dbm:Column oim:id="_11" name="OrderID" IsNullable="0" /> 
                       <dbm:Column oim:id="_12" name="Date" IsNullable="1" /> 
                    </dbm:ColumnSetColumns>
                 </dbm:Table>
                 <dbm:Table oim:id="_5" name="OrderItem" EstimatedRows="100000">
                    <dbm:ColumnSetColumns>
                       <dbm:Column oim:id="_13" name="CustomerID" IsNullable="0" /> 
                       <dbm:Column oim:id="_14" name="OrderID" IsNullable="0" /> 
                       <dbm:Column oim:id="_15" name="LineNo" IsNullable="0" /> 
                       <dbm:Column oim:id="_16" name="Description" IsNullable="1" /> 
                       <dbm:Column oim:id="_17" name="Quantity" IsNullable="0" /> 
                       <dbm:Column oim:id="_18" name="UnitPrice" IsNullable="0" /> 
                    </dbm:ColumnSetColumns>
                    <dbm:TableUniqueKeys>
                       <dbm:UniqueKey oim:id="_19" name="PK_OrderItem" IsPrimary="1">
                          <dbm:KeyColumns>
                             <dbm:Column oim:href="#_14" /> 
                             <dbm:Column oim:href="#_15" /> 
                          </dbm:KeyColumns>
                       </dbm:UniqueKey>
                    </dbm:TableUniqueKeys>
                 </dbm:Table>
              </dbm:SchemaTables>
           </dbm:Schema>
        </dbm:CatalogSchemas>
     </dbm:Catalog>
  </oim:Transfer>

See Also

Using XML Encoding

XML Encoding Reference

XML in Meta Data Services

Show:
© 2014 Microsoft