sys.xml_schema_component_placements (Transact-SQL)
Applies to: 
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
The visibility of the metadata in catalog views is limited to securables that a user either owns, or on which the user was granted some permission. For more information, see Metadata Visibility Configuration.
See Also
Catalog Views (Transact-SQL)
XML Schemas (XML Type System) Catalog Views (Transact-SQL)
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for