Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

sys.xml_schema_component_placements (Transact-SQL)

Returns a row per placement for XML schema components.

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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.