sys.xml_schema_elements (Transact-SQL)
Applies to: SQL Server
Returns a row per XML schema component that is a Type, symbol_space of E.
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. |
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