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.
|
Annotation |
Description |
|---|---|
|
encode |
When an XML element or attribute is mapped to a SQL Server BLOB column, allows requesting a reference (URI) to be returned and used later to return BLOB data. Available for: Element, Attribute |
|
field |
Maps an XML item to a database column. Available for: Element, Attribute |
|
hide |
Hides the element or attribute specified in the schema in the resulting XML document. Available for: Element, Attribute |
|
is-constant |
Creates an XML element that does not map to any table. The element is displayed in the query output. Available for: Element |
|
key-fields |
Allows specification of columns that uniquely identify the rows in a table. Available for: Element |
|
limit-field |
Allows limiting the values that are returned on the basis of a limiting value. Available for: Element, Attribute |
|
limit-value |
Allows limiting the values that are returned on the basis of a limiting value. Available for: Element, Attribute |
|
mapped |
Allows schema items to be excluded from the result. Available for: Element, Attribute |
|
max-depth |
Allows you to specify depth in recursive relationships that are specified in the schema. Available for: Element |
|
overflow-field |
Identifies the database column that contains the overflow data. Available for: Element |
|
relation |
Maps an XML item to a database table. Available for: Element |
|
relationship-child |
Specifies an element as the child table in a reference (To define only in the child element property sheet). Available for: Element |
|
relationship-child-key |
Specifies an attribute as the foreign key of a child table in a reference (To define only in the child element property sheet). Available for: Element |
|
relationship-parent |
Specifies an element as the parent table in a reference (To define only in the child element property sheet). Available for: Element |
|
relationship-parent-key |
Specifies an attribute as the primary key of a parent table in a reference (To define only in the child element property sheet). Available for: Element |
|
use-cdata |
Allows specifying CDATA sections to be used for certain elements in the XML document. Available for: Element |
|
prefix |
Creates valid XML ID, IDREF, and IDREFS. Prepends the values of ID, IDREF, and IDREFS with a string. Available for: Attribute |