How to apply defaults constraint to an XML data type column

An xml column type can be assigned a default XML instance in a table.

It can be done in 2 ways:

1.by using an XML constant

Syntax:
CREATE TABLE T (XmlColumn xml default N'<element1/><element2/>')

2.by using an explicit cast to the xml type.

Syntax:
CREATE TABLE T (XmlColumn xml
                default CAST(N'<element1/><element2/>' AS xml))

SQL Server also supports NULL and NOT NULL constraints on columns of xml type.

Example:
CREATE TABLE T (XmlColumn xml NOT NULL) 

<<Previous   Next>>