| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | f1_keywords | helpviewer_keywords | dev_langs | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
sys.xml_schema_types (Transact-SQL) |
sys.xml_schema_types (Transact-SQL) |
rwestMSFT |
randolphwest |
06/10/2016 |
sql |
system-objects |
reference |
|
|
|
[!INCLUDE SQL Server]
Returns a row per XML schema component that is a Type, symbol_space of T.
| 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) |
[!INCLUDEssCatViewPerm] For more information, see Metadata Visibility Configuration.
Catalog Views (Transact-SQL)
XML Schemas (XML Type System) Catalog Views (Transact-SQL)