Export (0) Print
Expand All

sys.xml_schema_attributes (Transact-SQL)

Returns a row per XML schema component that is an attribute, symbol_space of A.

Applies to: SQL Server (SQL Server 2008 through current version).

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.

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft