sys.xml_schema_elements (Transact-SQL)
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
In SQL Server 2005 and later versions, 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.