sys.parameter_xml_schema_collection_usages (Transact-SQL)


Updated: June 10, 2016

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

Returns a row for each parameter that is validated by an XML schema.

Column nameData typeDescription
object_idintThe ID of the object to which this parameter belongs.
parameter_idintThe ID of the parameter. Is unique within the object.
xml_collection_idintThe ID of the XML schema collection that contains the validating XML schema namespace of the parameter.

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