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
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
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
TypeColumn
Event that causes the trigger to fire.
[Column("type")]
[NotNull]
public int TypeColumn { get; set; }
Property Value
TypeDesc
Description of the event that causes the trigger to fire.
[Column("type_desc")]
[NotNull]
public string TypeDesc { get; set; }