Chapter 6 Working with XML and Databases
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 |
| Copyright (C) 2008. Sybase Inc. All rights reserved. |
| |