If your DBMS supports it, PowerDesigner allows you to create XML tables and views. An XML table does not contain columns, and instead stores an XML document. You must associate the table with a registered XML schema to validate the XML document stored in the table, and can specify a root element for the structure stored in your table.
When you select the XML in the Type field, the Column tab is removed and the following properties are added to the General tab:
|
Property |
Description |
|---|---|
|
Schema |
Enter the target namespace or name of an XML model (see XML Modeling) or use the Select tool to the right of the field to connect to the database and select a registered schema. The schema must be registered in the database to be used for validating XML documents. |
|
Element |
Allows you to specify a root element in the XML document. You can enter an element name or click the Select tool to the right of the field to select an element from an XML model open in the workspace or from the schema registered in the database If you select an element from a PowerDesigner XML model, the Schema property is set to the XML model target namespace. |