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:

C# 8.0 and .NET Core 3.0 – Modern Cross-Platform Development: Build applications with C#, .NET Core, Entity Framework Core, ASP.NET Core, and ML.NET using Visual Studio Code, 4th Edition
ASP.NET Core 3 and Angular 9: Full stack web development with .NET Core 3.1 and Angular 9, 3rd Edition
C# in Depth, 4th Edition

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.