Export (0) Print
Expand All

sys.xml_schema_types (Transact-SQL)

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

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_abstract

bit

1 = Type is an abstract type. All instances of an element of this type must use xsi:type to indicate a derived type that is not abstract.

0 = Type is not abstract. (default)

allows_mixed_content

bit

1 = Mixed content is allowed

0 = Mixed content is not allowed. (default)

is_extension_blocked

bit

1 = Replacement with an extension of the type is blocked in instances when the block attribute on the complexType definition or the blockDefault attribute of the ancestor <schema> element information item is set to "extension" or "#all".

0 =Replacement with extension is not blocked.

is_restriction_blocked

bit

1 = Replacement with a restriction of the type is blocked in instances when the block attribute on the complexType definition or the blockDefault attribute of the ancestor <schema> element information item is set to "restriction" or "#all".

0 = Replacement with restriction is not blocked. (default)

is_final_extension

bit

1 = Derivation by extension of the type is blocked when the final attribute on the complexType definition or the finalDefault attribute of the ancestor <schema> element information item is set to "extension" or "#all".

0 = Extension is allowed. (default)

is_final_restriction

bit

1 = Derivation by restriction of the type is blocked when the final attribute on the simple or complexType definition or the finalDefault attribute of the ancestor <schema> element information item is set to "restriction" or "#all".

0 = Restriction is allowed. (default)

is_final_list_member

bit

1 = This simple type cannot be used as the item type in a list.

0 = This type is a complex type, or it can be used as list item type. (default)

is_final_union_member

bit

1 = This simple type cannot be used as the member type of a union type.

0 = This type is a complex type. or it can be used as union member type. (default)

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