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.

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.