Table: dbo.triggers (Triggers)

Schema dbo
Name triggers
Title Triggers
Module Schema and Metadata

Holds table triggers.

Columns
PK Name Data type Null Attributes Description
1 trigger_id int Identity / Auto increment column Row ID.
Row ID.
Identity / Auto increment column
2 table_id int Table the trigger is related to. Ref: tables.
Table the trigger is related to. Ref: tables.
3 name nvarchar(250) Trigger name.
Trigger name.
4 description nvarchar(MAX) Trigger description defined with Dataedo.
Trigger description defined with Dataedo.
5 before bit Default: 0 Is triggered before (1 - yes)
Is triggered before (1 - yes)
Default: 0
6 after bit Default: 0 Is triggered after (1 - yes)
Is triggered after (1 - yes)
Default: 0
7 instead_of bit Default: 0 Is triggered instead of (1 - yes)
Is triggered instead of (1 - yes)
Default: 0
8 on_insert bit Default: 0 Is triggered on insert (1 - yes)
Is triggered on insert (1 - yes)
Default: 0
9 on_update bit Default: 0 Is triggered on update (1 - yes)
Is triggered on update (1 - yes)
Default: 0
10 on_delete bit Default: 0 Is triggered on delete (1 - yes)
Is triggered on delete (1 - yes)
Default: 0
11 disabled bit Default: 0 Is disabled (1 - yes)
Is disabled (1 - yes)
Default: 0
12 definition nvarchar(MAX) Trigger script imported from DBMS.
Trigger script imported from DBMS.
13 status char(1) Default: 'A' 'D' if trigger was deleted from DBMS, 'A' otherwise
'D' if trigger was deleted from DBMS, 'A' otherwise
Default: 'A'
14 creation_date datetime Default: getdate() Standard row creation timestamp.
Standard row creation timestamp.
Default: getdate()
15 created_by nvarchar(100) Default: user_name() Database/Dataedo username that created row.
Database/Dataedo username that created row.
Default: user_name()
16 last_modification_date datetime Default: getdate() Standard row last update timestamp.
Standard row last update timestamp.
Default: getdate()
17 modified_by nvarchar(100) Default: user_name() Database/Dataedo username that last updated row.
Database/Dataedo username that last updated row.
Default: user_name()
Relations
Foreign table Primary table Join Title / Name / Description
dbo.triggers dbo.tables dbo.triggers.table_id = dbo.tables.table_id FK_triggers_table
dbo.triggers.table_id = dbo.tables.table_id
FK_triggers_table
Unique keys
Key name Columns Description
PK_triggers trigger_id Table primary key.
Table primary key.
Triggers
Key name When Description
trg_triggers_Modify After Insert, Update Standard insert/update trigger setting last_modification_date, modified by columns
Standard insert/update trigger setting last_modification_date, modified by columns
Uses
Name
dbo.triggers (Triggers)
Exported: 2017-05-15 08:09, Last imported: 2017-04-06 15:30