sys.column_xml_schema_collection_usages (Transact-SQL)sys.column_xml_schema_collection_usages (Transact-SQL)

适用于:Applies to: 是SQL ServerSQL Server(所有支持的版本)yesSQL ServerSQL Server (all supported versions) 适用于:Applies to: 是SQL ServerSQL Server(所有支持的版本)yesSQL ServerSQL Server (all supported versions)

为通过 XML 架构验证的每一列返回一行。Returns a row for each column that is validated by an XML schema.

列名称Column name 数据类型Data type 说明Description
object_idobject_id intint 此列所属的对象的 ID。The ID of the object to which this column belongs.
column_idcolumn_id intint 列的 ID。The ID of the column. 在对象中是唯一的。Is unique within the object.
xml_collection_idxml_collection_id intint 包含列的验证 XML 架构命名空间的集合的 ID。The ID of the collection that contains the validating XML schema namespace of the column.

权限Permissions

目录视图中仅显示用户拥有的安全对象的元数据,或用户对其拥有某些权限的安全对象的元数据。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. 有关详细信息,请参阅 Metadata Visibility ConfigurationFor more information, see Metadata Visibility Configuration.

另请参阅See Also

目录视图 (Transact-SQL) Catalog Views (Transact-SQL)
XML 架构 (XML 类型系统) 目录视图 (Transact-sql)XML Schemas (XML Type System) Catalog Views (Transact-SQL)