sys.xml_schema_types (Transact-SQL)
Applies to: 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) |
Permissions
The visibility of the metadata in catalog views is limited to securables that a user either owns, or on which the user was granted some permission. For more information, see Metadata Visibility Configuration.
See Also
Catalog Views (Transact-SQL)
XML Schemas (XML Type System) Catalog Views (Transact-SQL)
Phản hồi
https://aka.ms/ContentUserFeedback.
Sắp ra mắt: Trong năm 2024, chúng tôi sẽ dần gỡ bỏ Sự cố với GitHub dưới dạng cơ chế phản hồi cho nội dung và thay thế bằng hệ thống phản hồi mới. Để biết thêm thông tin, hãy xem:Gửi và xem ý kiến phản hồi dành cho