Some DBMS support tables and views of XML type.
An XML table is used to store an XML document, it does not contain columns. It is possible to associate this table with an XML schema registered in a relational database, in this case the schema is used to validate the XML document stored in the table.
If you select the XML type in the Type list, the Column tab disappears and the following additional properties appear in the table property sheet:
Property |
Description |
---|---|
Schema |
Allows you to enter the target namespace or the name of an XML model. The schema must be registered in the database to be used for validating XML documents. You can: If you select an element from an XML model open in the PowerDesigner workspace, the Schema property is automatically initialized with the XML model target namespace. Note that this schema must also be registered in the database to be used for validating XML documents |
Element |
Allows you to select a root element in the XML document. You can: |