XML Data Type Variables and Columns

You can create columns and variables of the xml type and store XML instances in them. This section describes how to work with columns and variables of the xml type.

In This Section

Topic	Description
Creating XML Data Type Variables and Columns	Describes how to create xml data type variables and columns, and how to assign defaults and specify constraints for these columns.
Modifying Tables (XML)	Describes how to modify tables that include columns of the xml data type.
Creating Views (XML)	Describes how to use xml data type columns to create views.
Indexes on XML Data Type Columns	Describes how to create indexes on xml data type columns. This section includes information about the differences between primary and secondary indexes, and information about full-text indexing of xml data type columns.
Using XML in Computed Columns	Describes how to create computed columns from a column of xml type.
Typed XML Compared to Untyped XML	Describes the differences between typed and untyped XML.

See Also

Concepts

Implementing XML in SQL Server