XSD Annotations (SQLXML 4.0)


The following table lists the XSD annotations that were introduced in SQL Server 2005, and compares them with the XDR annotations that were introduced in SQL Server 2000.

XSD annotationDescriptionTopic linkXDR annotation
sql:encodeWhen an XML element or attribute is mapped to a SQL Server BLOB column, allows requesting a reference URI. This URI can be used later to return BLOB data.Requesting URL References to BLOB Data Using sql:encode (SQLXML 4.0)url-encode
sql:guidAllows you to specify whether to use a GUID value generated by SQL Server or use the value provided in the updategram for that column.Using the sql:identity and sql:guid AnnotationsNot supported
sql:hideHides the element or attribute that is specified in the schema in the resulting XML document.Hiding Elements and Attributes by Using sql:hideNot supported
sql:identityCan be specified on any node that maps to an IDENTITY-type database column. The value specified for this annotation defines how the corresponding IDENTITY-type column in the database is updated.Using the sql:identity and sql:guid AnnotationsNot supported
sql:inverseInstructs the updategram logic to inverse its interpretation of the parent-child relationship that has been specified using <sql:relationship>.Specifying the sql:inverse Attribute on sql:relationship (SQLXML 4.0)Not supported
sql:is-constantCreates an XML element that does not map to any table. The element appears in the query output.Creating Constant Elements Using sql:is-constant (SQLXML 4.0)Same
sql:key-fieldsAllows specification of column(s) that uniquely identify the rows in a table.Identifying Key Columns Using sql:key-fields (SQLXML 4.0)Same

Allows limiting the values that are returned on the basis of a limiting value.Filtering Values Using sql:limit-field and sql:limit-value (SQLXML 4.0)Same
sql:mappedAllows schema items to be excluded from the result.Excluding Schema Elements from the Resulting XML Document Using sql:mapped (SQLXML 4.0)map-field
sql:max-depthAllows you to specify depth in recursive relationships that are specified in the schema.Specifying Depth in Recursive Relationships by Using sql:max-depthNot supported
sql:overflow-fieldIdentifies the database column that contains the overflow data.Retrieving Unconsumed Data Using the sql:overflow-field (SQLXML 4.0)Same
sql:prefixCreates valid XML ID, IDREF, and IDREFS. Prepends the values of ID, IDREF, and IDREFS with a string.Creating Valid ID, IDREF, and IDREFS Type Attributes Using sql:prefix (SQLXML 4.0)Same
sql:relationshipSpecifies relationships between XML elements. The parent, child, parent-key, and child-key attributes are used to establish the relationship.Specifying Relationships Using sql:relationship (SQLXML 4.0)The attribute names are different:




sql:use-cdataAllows specifying CDATA sections to be used for certain elements in the XML document.Creating CDATA Sections Using sql:use-cdata (SQLXML 4.0)Same
System_CAPS_ICON_note.jpg Note

The XSD native targetNamespace attribute replaces the target-namespace annotation that was introduced in the SQL Server 2000 XDR mapping schema.

Specifying a Target Namespace Using the targetNamespace Attribute (SQLXML 4.0)

Community Additions