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 √ Azure SQL Database √ Azure SQL Managed Instance

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
Inherited Members
Extension Methods

Properties

EventGroupType

event_group_type NULL int

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

event_group_type_desc NULL nvarchar(60)

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

is_first NULL bit

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

is_last NULL bit

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

is_trigger_event NULL bit

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

object_id NOT NULL int

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

Type

type NOT NULL int

Event that causes the trigger to fire. 
[Column("type")]
[NotNull]
public int Type { get; set; }

Property Value

int

TypeDesc

type_desc NOT NULL nvarchar(60)

Description of the event that causes the trigger to fire. 
[Column("type_desc")]
[NotNull]
public string TypeDesc { get; set; }

Property Value

string