Online Documentation for SQL Administrator for SQL Server

XML options

The XML tab is only available for XML field type and for user-defined types based on XML type.

XML schema collection

Use the drop-down list to select an XML schema collection to be used by this field.

The XML schema collection stores the imported XML schemas.

The schemas in the collection are used to validate the XML instances. By default, instances stored in the typed xml column are stored as XML content. For typed xml columns, you can constrain the column to allow only single, top-level elements for each instance stored in it. You can do this by selecting the Allows only one top-level element (DOCUMENT) option.