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