Online Documentation for SQL Manager for SQL server

Setting XML properties

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

The xml data type is a built-in data type in SQL Server and is somewhat similar to other built-in types such as int and varchar. As with other built-in types, you can use the xml data type as a column type when you create a table as a variable type, a parameter type, a function-return type, or in CAST and CONVERT.

XML schema collection

Use the drop-down list to select an XML Schema Collection to be used by this column.

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 Document option.

The Stored as group allows you to select the way your xml data will be stored: as Content or as a Document.