Table of Contents

Class ObjectSchema.TriggerEvent

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

sys.trigger_events (Transact-SQL)

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

Contains a row per event for which a trigger fires.

note


sys.trigger_events does not apply to event notifications.


See sys.trigger_events.

[Table(Schema = "sys", Name = "trigger_events", IsView = true)]
public class ObjectSchema.TriggerEvent
Inheritance
ObjectSchema.TriggerEvent
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

IsFirst

Trigger is marked to be the first to fire for this event.

[Column("is_first")]
[Nullable]
public bool? IsFirst { get; set; }

Property Value

bool?

IsLast

Trigger is marked to be the last to fire for this event.

[Column("is_last")]
[Nullable]
public bool? IsLast { get; set; }

Property Value

bool?

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