sys.xml_schema_elements (Transact-SQL)

Returns a row per XML schema component that is a Type, symbol_space of E.

Column name Data type Description

<inherited columns>

--

Inherits columns from sys.xml_schema_components.

is_default_fixed

bit

1 = Default value is a fixed value. This value cannot be overridden in XML instance.

0 = Default value is not a fixed value for the element. (default).

is_abstract

bit

1 = Element is abstract and cannot be used in an instance document. A member of the substitution group of the element must appear in the instance document.

0 = Element is not abstract. (default).

is_nillable

bit

1 = Element is nillable.

0 = Element is not nillable. (default)

must_be_qualified

bit

1 = Element must be explicitly namespace qualified.

0 = Element may be implicitly namespace qualified. (default)

is_extension_blocked

bit

1 = Replacement with an instance of an extension type is blocked.

0 = Replacement with extension type is allowed. (default)

is_restriction_blocked

bit

1 = Replacement with an instance of a restriction type is blocked.

0 = Replacement with restriction type is allowed. (default)

is_substitution_blocked

bit

1 = Instance of a substitution group cannot be used.

0 = Replacement with substitution group is permitted. (default)

is_final_extension

bit

1 = Replacement with an instance of an extension type is disallowed.

0 = Replacement in an instance of an extension type is allowed. (default)

is_final_restriction

bit

1 = Replacement with an instance of a restriction type is disallowed.

0 = Replacement in an instance of a restriction type is allowed. (default)

default_value

nvarchar (4000)

Default value of the element. NULL if a default value is not supplied.

See Also

Reference

Catalog Views (Transact-SQL)
XML Schemas (XML Type System) Catalog Views (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance