sys.xml_schema_wildcards (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 per XML schema component that is an Attribute-Wildcard (kind of V) or Element-Wildcard (kind of W), both with symbol_space of N.

Column nameData typeDescription
<inherited columns>Inherits columns from sys.xml_schema_components.
process_contentchar(1)Indicates how contents are processed.

S = Strict validation (must validate)

L = Lax validation (validate if possible)

P = Skip validation
process_content_descnvarchar(60)Description of how contents are processed:



disallow_namespacesbit0 = Namespaces enumerated in sys.xml_schema_wildcard_namespaces are the only ones allowed.

1 = Namespaces are the only ones disallowed.

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