Table of Contents

Class ObjectSchema.ServerTrigger

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

sys.server_triggers (Transact-SQL)

Applies to: √ SQL Server (all supported versions)

Contains the set of all server-level DDL triggers with object_type of TR or TA. In the case of CLR triggers, the assembly must be loaded into the master database. All server-level DDL trigger names exist in a single, global scope.


See sys.server_triggers.

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

Properties

CreateDate

Date the trigger was created.

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

Property Value

DateTime

IsDisabled

1 = Trigger is disabled.

[Column("is_disabled")]
[NotNull]
public bool IsDisabled { get; set; }

Property Value

bool

IsMSShipped

Trigger created on behalf of the user by an internal SQL Server component.

[Column("is_ms_shipped")]
[NotNull]
public bool IsMSShipped { get; set; }

Property Value

bool

ModifyDate

Date the trigger was last modified by using an ALTER statement.

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

Property Value

DateTime

Name

Name of the trigger.

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

Property Value

string

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 object.

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

Property Value

int

ParentClass

Class of parent. Is always:

100 = Server

[Column("parent_class")]
[NotNull]
public byte ParentClass { get; set; }

Property Value

byte

ParentClassDesc

Description of class of parent. Is always:

SERVER.

[Column("parent_class_desc")]
[Nullable]
public string? ParentClassDesc { get; set; }

Property Value

string

ParentID

Always 0 for triggers on the SERVER.

[Column("parent_id")]
[NotNull]
public int ParentID { get; set; }

Property Value

int

TypeColumn

Object type:

TA = Assembly (CLR) trigger

TR = SQL trigger

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

Property Value

string

TypeDesc

Description of the class of the object type.

CLR_TRIGGER

SQL_TRIGGER

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

Property Value

string