title

description

author

ms.author

ms.reviewer

ms.date

ms.service

ms.subservice

ms.topic

f1_keywords

helpviewer_keywords

dev_langs

sys.xml_schema_component_placements (Transact-SQL)

rwestMSFT

randolphwest

mikeray

06/10/2016

sql

system-objects

reference

sys.xml_schema_component_placements

xml_schema_component_placements_TSQL

xml_schema_component_placements

sys.xml_schema_component_placements_TSQL

sys.xml_schema_component_placements catalog view

TSQL

sys.xml_schema_component_placements (Transact-SQL)

[!INCLUDE SQL Server]

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