Export (0) Print
Expand All

sys.column_xml_schema_collection_usages (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 for each column that is validated by an XML schema.

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

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

© 2016 Microsoft