sys.xml_schema_types (Transact-SQL)

 

Updated: June 10, 2016

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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 nameData typeDescription
<inherited columns>Inherits columns from sys.xml_schema_components.
is_abstractbit1 = 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_contentbit1 = Mixed content is allowed

0 = Mixed content is not allowed. (default)
is_extension_blockedbit1 = 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_blockedbit1 = 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_extensionbit1 = 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_restrictionbit1 = 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_memberbit1 = 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_memberbit1 = 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.

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

Community Additions

ADD
Show: