United States (English)

Home Library Learn Samples Downloads Support Community Forums

MSDN Library

Servers and Enterprise Development

SQL Server

SQL Server 2005

Product Documentation

SQL Server 2005 Documentation

SQL Server 2005 Books Online

SQL Server Database Engine

Using XML in SQL Server

Managing XML Schema Collections on the Server

DDL for Managing XML Schema Collections in the Database

Creating an XML Schema Collection

Modifying an XML Schema Collection

Dropping an XML Schema Collection

Minimize

This topic has not yet been rated - Rate this topic

Modifying an XML Schema Collection

SQL Server 2005

To add schema components to an existing XML schema collection, you can use the ALTER XML SCHEMA COLLECTION statement. For more information, see ALTER XML SCHEMA COLLECTION (Transact-SQL).

Reference

Managing XML Schema Collections on the Server
Guidelines and Limitations in Using XML Schema Collections on the Server
Permissions on an XML Schema Collection

Concepts

xml Data Type
Typed vs. Untyped XML

Help and Information

Getting SQL Server 2005 Assistance

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

© 2013 Microsoft. All rights reserved.