Dela via


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