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.