This documentation is archived and is not being maintained.

sys.column_xml_schema_collection_usages (Transact-SQL)

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.

In SQL Server 2005 and later versions, 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.

Show: