sys.xml_schema_attributes (Transact-SQL)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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

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.

See Also

XML Schemas (XML Type System) Catalog Views (Transact-SQL)
Catalog Views (Transact-SQL)