Previous Topic: Define SQL Server View Column PropertiesNext Topic: Define the Code Type for an Object in a SQL Server Property Editor

Creating Models › Target Servers for Physical Models › Database Property Editors › SQL Server Property Editors › SQL Server Common Functionality › 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 related to SQL Server. 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 2008, 2012, 2014, or 2016 physical model.

To define SQL Server XML schema collections

  1. Click Target - SQL Server, XML Schema Collections on the Model 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 New icon in property editors to create a new object on the toolbar to create a new XML schema collection. Use the Enter filter text box to filter a very large list of XML schema collections to quickly locate the one that you want to define.

    Name

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

    Schema

    Specifies the relational schema name.

    Generate

    Generates SQL during forward engineering. Clear the check box if you do not want to generate SQL.

  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 grant permissions to users, user groups, or roles on the selected XML schema collection.
  5. (Optional) Click the Comment tab and enter any comments that you want to associate with the object.
  6. (Optional) Click the UDP tab to work with user-defined properties for the object.
  7. (Optional) Click the Notes tab to view and edit user notes.
  8. Click Close.

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

More information:

Define Permissions for an Object in a SQL Server Property Editor

Add a Comment in a Property Editor