Reinforcing SQL Server Mappings with Extended Attributes

The Microsoft SQL Server extended model definition allows you to modify or reinforce the mapping resulting from the XML Builder Wizard via extended attributes.

Note:

If the element and attribute names match the table and column names, you do not need to define extended attributes for XML objects.

Select Model > Extended Model Definitions, and click the Import tool.
Click the XML in Database tab, select the Microsoft SQL Server xem, and click OK to attach it to your model.
Click OK to close the List of Extended Model Definitions and return to your model.
[optional] Click the Preview tab of the model property sheet, to preview the annotated schema.

Note:

You can also attach an XEM at model creation time by clicking the Select Extensions button on the New Model dialog.

SQL Server Extended Attributes for Elements and Attributes
You can set extended attributes on elements and attributes to reinforce their mapping to tables and columns, by opening their property sheets and clicking the Extended Attributes tab.

Parent topic: Generating an Annotated Schema for Microsoft SQL Server 2000