Class XmlSchema.XmlSchemaElement
- Namespace
- LinqToDB.Tools.DataProvider.SqlServer.Schemas
- Assembly
- linq2db.Tools.dll
sys.xml_schema_elements (Transact-SQL)
Applies to: √ SQL Server (all supported versions)
Returns a row per XML schema component that is a Type, symbol_space of E.
[Table(Schema = "sys", Name = "xml_schema_elements", IsView = true)]
public class XmlSchema.XmlSchemaElement- Inheritance
-
XmlSchema.XmlSchemaElement
- Extension Methods
Properties
BaseXmlComponentID
ID of the component from which this component is derived. NULL if there is none.
[Column("base_xml_component_id")]
[Nullable]
public int? BaseXmlComponentID { get; set; }Property Value
- int?
DefaultValue
Default value of the element. NULL if a default value is not supplied.
[Column("default_value")]
[Nullable]
public object? DefaultValue { get; set; }Property Value
Derivation
Derivation method for derived types:
N = None (not derived)
X = Extension
R = Restriction
S = Substitution
[Column("derivation")]
[NotNull]
public string Derivation { get; set; }Property Value
DerivationDesc
Description of derivation method for derived types:
NONE
EXTENSION
RESTRICTION
SUBSTITUTION
[Column("derivation_desc")]
[Nullable]
public string? DerivationDesc { get; set; }Property Value
IsAbstract
1 = Element is abstract and cannot be used in an instance document. A member of the substitution group of the element must appear in the instance document.
0 = Element is not abstract. (default).
[Column("is_abstract")]
[NotNull]
public bool IsAbstract { get; set; }Property Value
IsDefaultFixed
1 = Default value is a fixed value. This value cannot be overridden in XML instance.
0 = Default value is not a fixed value for the element. (default).
[Column("is_default_fixed")]
[NotNull]
public bool IsDefaultFixed { get; set; }Property Value
IsExtensionBlocked
1 = Replacement with an instance of an extension type is blocked.
0 = Replacement with extension type is allowed. (default)
[Column("is_extension_blocked")]
[NotNull]
public bool IsExtensionBlocked { get; set; }Property Value
IsFinalExtension
1 = Replacement with an instance of an extension type is disallowed.
0 = Replacement in an instance of an extension type is allowed. (default)
[Column("is_final_extension")]
[NotNull]
public bool IsFinalExtension { get; set; }Property Value
IsFinalRestriction
1 = Replacement with an instance of a restriction type is disallowed.
0 = Replacement in an instance of a restriction type is allowed. (default)
[Column("is_final_restriction")]
[NotNull]
public bool IsFinalRestriction { get; set; }Property Value
IsNillable
1 = Element is nillable.
0 = Element is not nillable. (default)
[Column("is_nillable")]
[NotNull]
public bool IsNillable { get; set; }Property Value
IsQualified
1 = This component has an explicit namespace qualifier.
0 = This is a locally scoped component. In this case, the pair, namespace_id, collection_id, refers to the 'no namespace' targetNamespace.
For wildcard components this value will be equal to 1.
[Column("is_qualified")]
[NotNull]
public bool IsQualified { get; set; }Property Value
IsRestrictionBlocked
1 = Replacement with an instance of a restriction type is blocked.
0 = Replacement with restriction type is allowed. (default)
[Column("is_restriction_blocked")]
[NotNull]
public bool IsRestrictionBlocked { get; set; }Property Value
IsSubstitutionBlocked
1 = Instance of a substitution group cannot be used.
0 = Replacement with substitution group is permitted. (default)
[Column("is_substitution_blocked")]
[NotNull]
public bool IsSubstitutionBlocked { get; set; }Property Value
Kind
Kind of XML schema component.
N = Any Type (special intrinsic component)
Z = Any Simple Type (special intrinsic component)
P = Primitive Type (intrinsic types)
S = Simple Type
L = List Type
U = Union Type
C = Complex Simple Type (derived from Simple)
K = Complex Type
E = Element
M = Model-Group
W = Element-Wildcard
A = Attribute
G = Attribute-Group
V = Attribute-Wildcard
[Column("kind")]
[NotNull]
public string Kind { get; set; }Property Value
KindDesc
Description of the kind of XML schema component:
ANY_TYPE
ANY_SIMPLE_TYPE
PRIMITIVE_TYPE
SIMPLE_TYPE
LIST_TYPE
UNION_TYPE
COMPLEX_SIMPLE_TYPE
COMPLEX_TYPE
ELEMENT
MODEL_GROUP
ELEMENT_WILDCARD
ATTRIBUTE
ATTRIBUTE_GROUP
ATTRIBUTE_WILDCARD
[Column("kind_desc")]
[Nullable]
public string? KindDesc { get; set; }Property Value
MustBeQualified
1 = Element must be explicitly namespace qualified.
0 = Element may be implicitly namespace qualified. (default)
[Column("must_be_qualified")]
[NotNull]
public bool MustBeQualified { get; set; }Property Value
Name
Unique name of the XML schema component. Is NULL if the component is unnamed.
[Column("name")]
[Nullable]
public string? Name { get; set; }Property Value
ScopingXmlComponentID
Unique ID of the scoping component. NULL if there is none (global scope).
[Column("scoping_xml_component_id")]
[Nullable]
public int? ScopingXmlComponentID { get; set; }Property Value
- int?
SymbolSpace
Space in which this symbol name is unique, based on kind:
N = None
T = Type
E = Element
M = Model-Group
A = Attribute
G = Attribute-Group
[Column("symbol_space")]
[NotNull]
public string SymbolSpace { get; set; }Property Value
SymbolSpaceDesc
Description of space in which this symbol name is unique, based on kind:
NONE
TYPE
ELEMENT
MODEL_GROUP
ATTRIBUTE
ATTRIBUTE_GROUP
[Column("symbol_space_desc")]
[Nullable]
public string? SymbolSpaceDesc { get; set; }Property Value
XmlCollectionID
ID of the XML schema collection that contains the namespace of this component.
[Column("xml_collection_id")]
[NotNull]
public int XmlCollectionID { get; set; }Property Value
XmlComponentID
Unique ID of the XML schema component in the database.
[Column("xml_component_id")]
[NotNull]
public int XmlComponentID { get; set; }Property Value
XmlNamespaceID
ID of the XML namespace within the collection.
[Column("xml_namespace_id")]
[NotNull]
public int XmlNamespaceID { get; set; }