Export (0) Print
Expand All

sys.xml_schema_elements (Transact-SQL)

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

Applies to: SQL Server (SQL Server 2008 through current version).

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.

The visibility of the metadata in catalog views is limited to securables that a user either owns or on which the user has been granted some permission. For more information, see Metadata Visibility Configuration.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft