Export (0) Print
Expand All

sys.xml_schema_component_placements (Transact-SQL)

Returns a row per placement for XML schema components.

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

Column name

Data type

Description

xml_component_id

int

ID of the XML schema component that owns this placement.

placement_id

int

ID of the placement. This is unique within the owning XML schema component.

placed_xml_component_id

int

ID of the placed XML schema component.

is_default_fixed

bit

1 = The default value is a fixed value. This value cannot be overridden in an XML instance.

0 = The value can be overridden.(default)

min_occurrences

int

Minimum number of placed component occurs.

max_occurrences

int

Maximum number of placed component occurs.

default_value

nvarchar (4000)

Default value if one is supplied. 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