sys.xml_schema_attributes (Transact-SQL)
Returns a row per XML schema component that is an attribute, symbol_space of A.
Column name |
Data type |
Description |
|---|---|---|
<inherited columns> |
-- |
Inherits from sys.xml_schema_components. |
is_default_fixed |
bit |
1 = The default value is a fixed value. This value cannot be overridden in an XML instance. 0 = The default value is not a fixed value for the attribute. (default) |
must_be_qualified |
bit |
1 = The attribute must be explicitly namespace qualified. 0 = The attribute may be implicitly namespace qualified. (default) |
default_value |
nvarchar (4000) |
Default value of the attribute. Is 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.