![](/images/new-backgrounds/1214202/214202473x1.webp)
Chapter 5 Exchanging data with databases supporting XML
The annotated schema appears in the editor window.
Note the SQL namespace (with the sql prefix) and the SQL annotations for tables (sql:relation), columns (sql:field) and reference (sql:relationship).
18 Click Close in the Result dialog box.
Reinforcing mapping with extended attributes
If you want to modify or reinforce the mapping resulting from the the XML Builder Wizard, you can define extended attributes for XML objects. Extended attributes are available from the Microsoft SQL Server extended model definition attached to the mapped XML model. If the element and attribute names match with the table and column names, you do not need to define extended attributes for XML objects.
You could generate an annotated schema without a PDM and the XML Builder Wizard, only through extended attributes, but it would not be the easiest way to proceed.
Caution
The following procedure assumes you have an XML model open in the workspace, targeted with XSD or XDR, mapped with a PDM, and linked to the Microsoft SQL Server extended model definition. (See Mapping XML objects to PDM objects)
XSM User's Guide | 225 |