How to assign an XML Schema Collection to a column in SQL server

Columns that use the xml data type can have the XML values validated against an XML schema collection. The schema collection must exist in the database before developers modify the table. If they create a new schema while modifying the table definition, the schema collection list will not include the new collection. When developers working with SQL Server “Denali”, MS SQL Server 2008 R2 and MS SQL Server 2005 want to assign an XML Schema Collection to a column, they should follow the next steps:

1. In Table Designer, highlight the column with the xml data type.

2. In Column Properties, open the XML Type Specification node.

3. In (Schema Collection), select the schema collection they wish to use for this column.