Physical Modeling › SQL Server Physical Property Editors › SQL Server Database Objects › Define SQL Server XML Schema Collections

Define SQL Server XML Schema Collections

XML schema collections are a way to manage XML schemas as metadata. An XML data type can be associated with an XML schema collection to enforce schema constraints on XML instances. The XML schema collection stores only the schema components that SQL server understands. Everything in the XML schema is not stored in the database. Use the SQL Server XML Schema Collection Editor to define schema collections in a SQL Server 2005/2008 physical model.

To define SQL Server XML schema collections

1. Click XML Schema Collections on the Database menu.

   The SQL Server XML Schema Collection Editor opens.

2. Select the XML schema collection in the Navigation Grid that you want to define and work with the following options:

   Note: Click New on the toolbar to create a new XML schema collection.

   • Name

     Displays the XML schema collection name. You can change the XML schema collection name in this field.

   • Schema

     Specifies the relational schema name.

3. Click the XML Schema tab and enter the expression in the text area. Use the Expression toolbar to cut, copy, and paste text.
4. Click the Permission tab to define the permissions for the XML schema collection.
5. (Optional) Click the Comment tab and enter any comments that you want to associate with the XML schema collection.
6. Click Close.

   The XML schema collection is defined and the SQL Server XML Schema Collection Editor closes.