Table of Contents

Class ObjectSchema.Event

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

sys.events (Transact-SQL)

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

Contains a row for each event for which a trigger or event notification fires. These events represent the event types that are specified when the trigger or event notification is created by using CREATE TRIGGER or CREATE EVENT NOTIFICATION.


See sys.events.

[Table(Schema = "sys", Name = "events", IsView = true)]
public class ObjectSchema.Event
Inheritance
ObjectSchema.Event
Extension Methods

Properties

EventGroupType

Event group on which the trigger or event notification is created, or null if not created on an event group.

[Column("event_group_type")]
[Nullable]
public int? EventGroupType { get; set; }

Property Value

int?

EventGroupTypeDesc

Description of the event group on which the trigger or event notification is created, or null if not created on an event group.

[Column("event_group_type_desc")]
[Nullable]
public string? EventGroupTypeDesc { get; set; }

Property Value

string

IsTriggerEvent

1 = Trigger event.

0 = Notification event.

[Column("is_trigger_event")]
[Nullable]
public bool? IsTriggerEvent { get; set; }

Property Value

bool?

Object

objects (sys.objects)

[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = false)]
public ObjectSchema.Object Object { get; set; }

Property Value

ObjectSchema.Object

ObjectID

ID of the trigger or event notification. This value, together with type, uniquely identifies the row.

[Column("object_id")]
[NotNull]
public int ObjectID { get; set; }

Property Value

int

TypeColumn

Event that causes the trigger to fire.

[Column("type")]
[NotNull]
public int TypeColumn { get; set; }

Property Value

int

TypeDesc

Description of the event that causes the trigger to fire.

[Column("type_desc")]
[NotNull]
public string TypeDesc { get; set; }

Property Value

string