sys.xml_schema_component_placements (Transact-SQL)

sys.xml_schema_component_placements (Transact-SQL)

 

Updated: June 10, 2016

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Returns a row per placement for XML schema components.

Column nameData typeDescription
xml_component_idintID of the XML schema component that owns this placement.
placement_idintID of the placement. This is unique within the owning XML schema component.
placed_xml_component_idintID of the placed XML schema component.
is_default_fixedbit1 = The default value is a fixed value. This value cannot be overridden in an XML instance.

0 = The value can be overridden.(default)
min_occurrencesintMinimum number of placed component occurs.
max_occurrencesintMaximum number of placed component occurs.
default_valuenvarchar (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.

Catalog Views (Transact-SQL)
XML Schemas (XML Type System) Catalog Views (Transact-SQL)

Community Additions

ADD
Show:
© 2016 Microsoft