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)
Σχόλια
https://aka.ms/ContentUserFeedback.
Σύντομα διαθέσιμα: Καθ' όλη τη διάρκεια του 2024 θα καταργήσουμε σταδιακά τα ζητήματα GitHub ως μηχανισμό ανάδρασης για το περιεχόμενο και θα το αντικαταστήσουμε με ένα νέο σύστημα ανάδρασης. Για περισσότερες πληροφορίες, ανατρέξτε στο θέμα:Υποβολή και προβολή σχολίων για