title
sys.column_xml_schema_collection_usages (Transact-SQL) | Microsoft Docs
ms.custom
ms.date
06/10/2016
ms.prod
sql
ms.prod_service
database-engine
ms.reviewer
ms.technology
system-objects
ms.topic
language-reference
f1_keywords
column_xml_schema_collection_usages_TSQL
sys.column_xml_schema_collection_usages
column_xml_schema_collection_usages
sys.column_xml_schema_collection_usages_TSQL
dev_langs
helpviewer_keywords
sys.column_xml_schema_collection_usages catalog view
ms.assetid
4fd1ec7f-b9dc-4ddb-ab3a-0d59ab05ad20
author
stevestein
ms.author
sstein
sys.column_xml_schema_collection_usages (Transact-SQL)
[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx-md ]
Returns a row for each column that is validated by an XML schema.
Column name
Data type
Description
object_id
int
The ID of the object to which this column belongs.
column_id
int
The ID of the column. Is unique within the object.
xml_collection_id
int
The ID of the collection that contains the validating XML schema namespace of the column.
[!INCLUDEssCatViewPerm ] For more information, see Metadata Visibility Configuration .
Catalog Views (Transact-SQL)
XML Schemas (XML Type System) Catalog Views (Transact-SQL)