Online Documentation for SQL Manager for SQL server
XML Schema Collections
Microsoft® SQL Server™ provides native storage of XML data through the XML data type. The XML Schema Collection stores the imported XML schemas and is then used to do the following:
- Validate XML instances
- Type the XML data as they are stored in the database
The XML stored in a column or variable that a schema is associated with is referred to as typed XML, because the schema provides the necessary data type information for the instance data. SQL Server uses this type information to optimize data storage.
Note that XML Schema Collection is a metadata entity like a table in the database, hence the XML Schema Collection can be created, modified and dropped.
XML Schema Collection Editor allows you to define XML schema collection properties. It opens automatically when you create a new XML schema collection and is available on editing an existing one.
To open a XML schema collection in XML Schema Collection Editor, double-click it in the DB Explorer tree.
- Using Navigation bar and Toolbar
- Creating/editing XML Schema Collection
- Browsing object dependencies
- Editing object description
- Viewing DDL definition
- Setting object permissions