Table of Contents

Class XmlSchema.XmlSchemaCollection

Namespace
LinqToDB.Tools.DataProvider.SqlServer.Schemas
Assembly
linq2db.Tools.dll

sys.xml_schema_collections (Transact-SQL)

Applies to: √ SQL Server (all supported versions) √ Azure SQL Database

Returns a row per XML schema collection. An XML schema collection is a named set of XSD definitions. The XML schema collection itself is contained in a relational schema, and it is identified by a schema-scoped Transact\-SQL name. The following tuples are unique: xml_collection_id, and schema_id and name.


See sys.xml_schema_collections.

[Table(Schema = "sys", Name = "xml_schema_collections", IsView = true)]
public class XmlSchema.XmlSchemaCollection
Inheritance
XmlSchema.XmlSchemaCollection
Extension Methods

Properties

CreateDate

Date the XML schema collection was created.

[Column("create_date")]
[NotNull]
public DateTime CreateDate { get; set; }

Property Value

DateTime

ModifyDate

Date the XML schema collection was last altered.

[Column("modify_date")]
[NotNull]
public DateTime ModifyDate { get; set; }

Property Value

DateTime

Name

Name of the XML schema collection.

[Column("name")]
[NotNull]
public string Name { get; set; }

Property Value

string

PrincipalID

ID of the individual owner if different from the schema owner. By default, schema-contained objects are owned by the schema owner. However, an alternate owner may be specified by using the ALTER AUTHORIZATION statement to change ownership.

NULL = No alternate individual owner.

[Column("principal_id")]
[Nullable]
public int? PrincipalID { get; set; }

Property Value

int?

SchemaID

ID of the relational schema that contains this XML schema collection.

[Column("schema_id")]
[NotNull]
public int SchemaID { get; set; }

Property Value

int

XmlCollectionID

ID of the XML schema collection. Unique within the database.

[Column("xml_collection_id")]
[NotNull]
public int XmlCollectionID { get; set; }

Property Value

int