dbo.triggers (Triggers) - Dataedo repository 7

Dataedo repository 7

- Dataedo repository 7
  - Modules
  - Tables

Documentation	Dataedo repository 7
Schema	dbo
Name	triggers
Title	Triggers
Module	Schema and Metadata
Type	Schema
Status	Active

Holds table triggers.

Columns

		Name	Data type	Attributes	References	Description	Type	Status
	1	trigger_id	int	Identity		Row ID.	Metadata	Active
Row ID. Identity Type: Metadata Status: Active
	2	table_id	int		dbo.tables (Tables and Views)	Table the trigger is related to. Ref: tables.	Metadata	Active
Table the trigger is related to. Ref: tables. References: dbo.tables (Tables and Views) Type: Metadata Status: Active
	3	name	nvarchar(250)			Trigger name.	Schema	Active
Trigger name. Type: Schema Status: Active
	4	type	nvarchar(100)	Default: N'TRIGGER'		Defines type of object classfied in Dataedo as trigger (visible in Trigger tab by table object). TRIGGER - "regular" trigger, RULE - PostgreSQL rule.	Schema	Active
Defines type of object classfied in Dataedo as trigger (visible in Trigger tab by table object). TRIGGER - "regular" trigger, RULE - PostgreSQL rule. Default: N'TRIGGER' Type: Schema Status: Active
	5	source	nvarchar(50)	Default: N'DBMS'		Source of the row: 'DBMS' for imported from database, 'USER' for manual defined by user in Dataedo repository	Metadata	Active
Source of the row: 'DBMS' for imported from database, 'USER' for manual defined by user in Dataedo repository Default: N'DBMS' Type: Metadata Status: Active
	6	status	char(1)	Default: 'A'		'D' if trigger was deleted from DBMS, 'A' otherwise	Metadata	Active
'D' if trigger was deleted from DBMS, 'A' otherwise Default: 'A' Type: Metadata Status: Active
	7	description	nvarchar(MAX)			Trigger description defined with Dataedo.	Documentation	Active
Trigger description defined with Dataedo. Type: Documentation Status: Active
	8	before	bit	Default: 0		Is trigger fired before operation (1 - yes)	Schema	Active
Is trigger fired before operation (1 - yes) Default: 0 Type: Schema Status: Active
	9	after	bit	Default: 0		Is trigger fired after operation (1 - yes)	Schema	Active
Is trigger fired after operation (1 - yes) Default: 0 Type: Schema Status: Active
	10	instead_of	bit	Default: 0		Is trigger fired instead of operation (1 - yes)	Schema	Active
Is trigger fired instead of operation (1 - yes) Default: 0 Type: Schema Status: Active
	11	on_insert	bit	Default: 0		Is trigger fired on insert operation (1 - yes)	Schema	Active
Is trigger fired on insert operation (1 - yes) Default: 0 Type: Schema Status: Active
	12	on_update	bit	Default: 0		Is trigger fired on update operation (1 - yes)	Schema	Active
Is trigger fired on update operation (1 - yes) Default: 0 Type: Schema Status: Active
	13	on_delete	bit	Default: 0		Is trigger fired on delete operation (1 - yes)	Schema	Active
Is trigger fired on delete operation (1 - yes) Default: 0 Type: Schema Status: Active
	14	disabled	bit	Default: 0		Is trigger disabled in DBMS (1 - yes)	Schema	Active
Is trigger disabled in DBMS (1 - yes) Default: 0 Type: Schema Status: Active
	15	definition	nvarchar(MAX)			Trigger script imported from DBMS	Schema	Active
Trigger script imported from DBMS Type: Schema Status: Active
	16	field1	nvarchar(MAX)			Custom field 1	Documentation	Active
Custom field 1 Type: Documentation Status: Active
	17	field2	nvarchar(MAX)			Custom field 2	Documentation	Active
Custom field 2 Type: Documentation Status: Active
	18	field3	nvarchar(MAX)			Custom field 3	Documentation	Active
Custom field 3 Type: Documentation Status: Active
	19	field4	nvarchar(MAX)			Custom field 4	Documentation	Active
Custom field 4 Type: Documentation Status: Active
	20	field5	nvarchar(MAX)			Custom field 5	Documentation	Active
Custom field 5 Type: Documentation Status: Active
	21	field6	nvarchar(MAX)			Custom field 6	Documentation	Active
Custom field 6 Type: Documentation Status: Active
	22	field7	nvarchar(MAX)			Custom field 7	Documentation	Active
Custom field 7 Type: Documentation Status: Active
	23	field8	nvarchar(MAX)			Custom field 8	Documentation	Active
Custom field 8 Type: Documentation Status: Active
	24	field9	nvarchar(MAX)			Custom field 9	Documentation	Active
Custom field 9 Type: Documentation Status: Active
	25	field10	nvarchar(MAX)			Custom field 10	Documentation	Active
Custom field 10 Type: Documentation Status: Active
	26	field11	nvarchar(MAX)			Custom field 11	Documentation	Active
Custom field 11 Type: Documentation Status: Active
	27	field12	nvarchar(MAX)			Custom field 12	Documentation	Active
Custom field 12 Type: Documentation Status: Active
	28	field13	nvarchar(MAX)			Custom field 13	Documentation	Active
Custom field 13 Type: Documentation Status: Active
	29	field14	nvarchar(MAX)			Custom field 14	Documentation	Active
Custom field 14 Type: Documentation Status: Active
	30	field15	nvarchar(MAX)			Custom field 15	Documentation	Active
Custom field 15 Type: Documentation Status: Active
	31	field16	nvarchar(MAX)			Custom field 16	Documentation	Active
Custom field 16 Type: Documentation Status: Active
	32	field17	nvarchar(MAX)			Custom field 17	Documentation	Active
Custom field 17 Type: Documentation Status: Active
	33	field18	nvarchar(MAX)			Custom field 18	Documentation	Active
Custom field 18 Type: Documentation Status: Active
	34	field19	nvarchar(MAX)			Custom field 19	Documentation	Active
Custom field 19 Type: Documentation Status: Active
	35	field20	nvarchar(MAX)			Custom field 20	Documentation	Active
Custom field 20 Type: Documentation Status: Active
	36	field21	nvarchar(MAX)			Custom field 21	Documentation	Active
Custom field 21 Type: Documentation Status: Active
	37	field22	nvarchar(MAX)			Custom field 22	Documentation	Active
Custom field 22 Type: Documentation Status: Active
	38	field23	nvarchar(MAX)			Custom field 23	Documentation	Active
Custom field 23 Type: Documentation Status: Active
	39	field24	nvarchar(MAX)			Custom field 24	Documentation	Active
Custom field 24 Type: Documentation Status: Active
	40	field25	nvarchar(MAX)			Custom field 25	Documentation	Active
Custom field 25 Type: Documentation Status: Active
	41	field26	nvarchar(MAX)			Custom field 26	Documentation	Active
Custom field 26 Type: Documentation Status: Active
	42	field27	nvarchar(MAX)			Custom field 27	Documentation	Active
Custom field 27 Type: Documentation Status: Active
	43	field28	nvarchar(MAX)			Custom field 28	Documentation	Active
Custom field 28 Type: Documentation Status: Active
	44	field29	nvarchar(MAX)			Custom field 29	Documentation	Active
Custom field 29 Type: Documentation Status: Active
	45	field30	nvarchar(MAX)			Custom field 30	Documentation	Active
Custom field 30 Type: Documentation Status: Active
	46	field31	nvarchar(MAX)			Custom field 31	Documentation	Active
Custom field 31 Type: Documentation Status: Active
	47	field32	nvarchar(MAX)			Custom field 32	Documentation	Active
Custom field 32 Type: Documentation Status: Active
	48	field33	nvarchar(MAX)			Custom field 33	Documentation	Active
Custom field 33 Type: Documentation Status: Active
	49	field34	nvarchar(MAX)			Custom field 34	Documentation	Active
Custom field 34 Type: Documentation Status: Active
	50	field35	nvarchar(MAX)			Custom field 35	Documentation	Active
Custom field 35 Type: Documentation Status: Active
	51	field36	nvarchar(MAX)			Custom field 36	Documentation	Active
Custom field 36 Type: Documentation Status: Active
	52	field37	nvarchar(MAX)			Custom field 37	Documentation	Active
Custom field 37 Type: Documentation Status: Active
	53	field38	nvarchar(MAX)			Custom field 38	Documentation	Active
Custom field 38 Type: Documentation Status: Active
	54	field39	nvarchar(MAX)			Custom field 39	Documentation	Active
Custom field 39 Type: Documentation Status: Active
	55	field40	nvarchar(MAX)			Custom field 40	Documentation	Active
Custom field 40 Type: Documentation Status: Active
	56	creation_date	datetime	Default: getdate()		Standard row creation timestamp	Metadata	Active
Standard row creation timestamp Default: getdate() Type: Metadata Status: Active
	57	created_by	nvarchar(1024)	Default: user_name()		Dataedo username that created row	Metadata	Active
Dataedo username that created row Default: user_name() Type: Metadata Status: Active
	58	last_modification_date	datetime	Default: getdate()		Standard row last update timestamp	Metadata	Active
Standard row last update timestamp Default: getdate() Type: Metadata Status: Active
	59	modified_by	nvarchar(1024)	Default: user_name()		Dataedo username that last updated row	Metadata	Active
Dataedo username that last updated row Default: user_name() Type: Metadata Status: Active
	60	source_id	int			For internal use only	Internal	Active
For internal use only Type: Internal Status: Active
	61	temp_sync_status	bit	Default: 0		For internal use only	Internal	Active
For internal use only Default: 0 Type: Internal Status: Active
	62	update_id	int		dbo.schema_updates (Imports/Updates)	Id of the last schema import/update from source database where element was created/modified	Metadata	Active
Id of the last schema import/update from source database where element was created/modified References: dbo.schema_updates (Imports/Updates) Type: Metadata Status: Active

Relations

Foreign table	Primary table	Join	Title / Name / Description
dbo.triggers (Triggers)	dbo.schema_updates (Imports/Updates)	dbo.triggers.update_id = dbo.schema_updates.update_id	fk_triggers_schema_updates
dbo.triggers.update_id = dbo.schema_updates.update_id Name: fk_triggers_schema_updates
dbo.triggers (Triggers)	dbo.tables (Tables and Views)	dbo.triggers.table_id = dbo.tables.table_id	FK_triggers_table
dbo.triggers.table_id = dbo.tables.table_id Name: FK_triggers_table
dbo.triggers_changes	dbo.triggers (Triggers)	dbo.triggers_changes.trigger_id = dbo.triggers.trigger_id	fk_triggers_changes_triggers
dbo.triggers_changes.trigger_id = dbo.triggers.trigger_id Name: fk_triggers_changes_triggers

Unique keys

	Key name	Columns	Description
	PK_triggers	trigger_id	Table primary key
Table primary key

Triggers

	Key name	When	Description
	trg_triggers_change_track_insert	After Insert	Schema change tracking trigger
-- ============================================= -- Description: Insert trigger's changes to schema change tracking tables -- ============================================= CREATE TRIGGER [trg_triggers_change_track_insert] ON [triggers] FOR INSERT AS -- skip manual objects created through Dataedo application IF EXISTS ( SELECT TOP (1) 1 FROM [inserted] WHERE [source] = 'USER' ) BEGIN RETURN; END; INSERT INTO [triggers_changes] ([database_id], [trigger_id], [table_id], [name], [before], [after], [instead_of], [on_insert], [on_update], [on_delete], [disabled], [definition], [type], [operation], [valid_from], [update_id] ) SELECT [t].[database_id], [i].[trigger_id], [i].[table_id], [i].[name], [i].[before], [i].[after], [i].[instead_of], [i].[on_insert], [i].[on_update], [i].[on_delete], [i].[disabled], [i].[definition], [i].[type], 'ADDED', GETDATE(), [i].[update_id] FROM [inserted] [i] LEFT OUTER JOIN [tables] [t] ON [i].[table_id] = [t].[table_id] WHERE NOT EXISTS ( SELECT 1 FROM [schema_updates] [u] WHERE [u].[update_id] = [i].[update_id] AND [u].[type] = 'IMPORT' );
Schema change tracking trigger
-- ============================================= -- Description: Insert trigger's changes to schema change tracking tables -- ============================================= CREATE TRIGGER [trg_triggers_change_track_insert] ON [triggers] FOR INSERT AS -- skip manual objects created through Dataedo application IF EXISTS ( SELECT TOP (1) 1 FROM [inserted] WHERE [source] = 'USER' ) BEGIN RETURN; END; INSERT INTO [triggers_changes] ([database_id], [trigger_id], [table_id], [name], [before], [after], [instead_of], [on_insert], [on_update], [on_delete], [disabled], [definition], [type], [operation], [valid_from], [update_id] ) SELECT [t].[database_id], [i].[trigger_id], [i].[table_id], [i].[name], [i].[before], [i].[after], [i].[instead_of], [i].[on_insert], [i].[on_update], [i].[on_delete], [i].[disabled], [i].[definition], [i].[type], 'ADDED', GETDATE(), [i].[update_id] FROM [inserted] [i] LEFT OUTER JOIN [tables] [t] ON [i].[table_id] = [t].[table_id] WHERE NOT EXISTS ( SELECT 1 FROM [schema_updates] [u] WHERE [u].[update_id] = [i].[update_id] AND [u].[type] = 'IMPORT' );
	trg_triggers_change_track_update	After Update	Schema change tracking trigger
-- ============================================= -- Description: Insert trigger's changes to schema change tracking tables -- ============================================= CREATE TRIGGER [trg_triggers_change_track_update] ON [triggers] FOR UPDATE AS -- skip manual objects created through Dataedo application IF EXISTS ( SELECT TOP (1) 1 FROM [INSERTED] WHERE [source] = 'USER' ) BEGIN RETURN; END; -- check if object property change IF EXISTS ( SELECT TOP (1) 1 FROM [inserted] [i] INNER JOIN [deleted] [d] ON [i].[trigger_id] = [d].[trigger_id] WHERE ISNULL([d].[table_id],'') <> [i].[table_id] OR ISNULL([d].[name],'') <> [i].[name] OR ISNULL([d].[before],'') <> [i].[before] OR ISNULL([d].[after],'') <> [i].[after] OR ISNULL([d].[instead_of],'') <> [i].[instead_of] OR ISNULL([d].[on_insert],'') <> [i].[on_insert] OR ISNULL([d].[on_update],'') <> [i].[on_update] OR ISNULL([d].[on_delete],'') <> [i].[on_delete] OR ISNULL([d].[disabled],'') <> [i].[disabled] OR ISNULL([d].[definition],'') <> [i].[definition] OR ISNULL([d].[type],'') <> [i].[type] ) BEGIN UPDATE [triggers_changes] SET [valid_to] = GETDATE() FROM [triggers_changes] [c] INNER JOIN [inserted] [u] ON [c].[table_id] = [u].[table_id] WHERE [valid_to] IS NULL; -- insert changes (before and after values) for trigger - when trigger was updated INSERT INTO [triggers_changes] ([database_id], [trigger_id], [table_id], [name], [before], [after], [instead_of], [on_insert], [on_update], [on_delete], [disabled], [definition], [before_before], [before_after], [before_instead_of], [before_on_insert], [before_on_update], [before_on_delete], [before_disabled], [before_definition], [type], [operation], [valid_from], [update_id] ) SELECT [t].[database_id], [i].[trigger_id], [i].[table_id], [i].[name], [i].[before], [i].[after], [i].[instead_of], [i].[on_insert], [i].[on_update], [i].[on_delete], [i].[disabled], [i].[definition], [d].[before], [d].[after], [d].[instead_of], [d].[on_insert], [d].[on_update], [d].[on_delete], [d].[disabled], [d].[definition], [d].[type], 'UPDATED', [cc].[valid_to], [i].[update_id] FROM [inserted] [i] INNER JOIN [deleted] [d] ON [i].[trigger_id] = [d].[trigger_id] LEFT OUTER JOIN [tables] [t] ON [d].[table_id] = [t].[table_id] OUTER APPLY ( SELECT MAX([valid_to]) AS [valid_to] FROM [triggers_changes] [c] WHERE [c].[trigger_id] = [d].[trigger_id] AND [c].[valid_to] IS NOT NULL ) [cc] WHERE [i].[status] = 'A' AND [d].[status] = 'A' AND (ISNULL([d].[table_id],'') <> [i].[table_id] OR ISNULL([d].[name],'') <> [i].[name] OR ISNULL([d].[before],'') <> [i].[before] OR ISNULL([d].[after],'') <> [i].[after] OR ISNULL([d].[instead_of],'') <> [i].[instead_of] OR ISNULL([d].[on_insert],'') <> [i].[on_insert] OR ISNULL([d].[on_update],'') <> [i].[on_update] OR ISNULL([d].[on_delete],'') <> [i].[on_delete] OR ISNULL([d].[disabled],'') <> [i].[disabled] OR ISNULL([d].[definition],'') <> [i].[definition] OR ISNULL([d].[type],'') <> [i].[type]); END; BEGIN -- insert changes (deleted values) for trigger - when trigger was deleted INSERT INTO [triggers_changes] ([database_id], [trigger_id], [table_id], [name], [before], [after], [instead_of], [on_insert], [on_update], [on_delete], [disabled], [definition], [type], [operation], [valid_to], [update_id] ) SELECT [t].[database_id], [d].[trigger_id], [d].[table_id], [d].[name], [d].[before], [d].[after], [d].[instead_of], [d].[on_insert], [d].[on_update], [d].[on_delete], [d].[disabled], [d].[definition], [d].[type], 'DELETED', GETDATE(), [i].[update_id] FROM [inserted] [i] INNER JOIN [deleted] [d] ON [i].[trigger_id] = [d].[trigger_id] LEFT OUTER JOIN [tables] [t] ON [d].[table_id] = [t].[table_id] WHERE [i].[status] = 'D' AND [d].[status] = 'A'; -- insert changes (updated values) for trigger - when trigger was restored INSERT INTO [triggers_changes] ([database_id], [trigger_id], [table_id], [name], [before], [after], [instead_of], [on_insert], [on_update], [on_delete], [disabled], [definition], [type], [operation], [valid_from], [update_id] ) SELECT [t].[database_id], [i].[trigger_id], [i].[table_id], [i].[name], [i].[before], [i].[after], [i].[instead_of], [i].[on_insert], [i].[on_update], [i].[on_delete], [i].[disabled], [i].[definition], [i].[type], 'ADDED', GETDATE(), [i].[update_id] FROM [inserted] [i] INNER JOIN [deleted] [d] ON [i].[trigger_id] = [d].[trigger_id] LEFT OUTER JOIN [tables] [t] ON [d].[table_id] = [t].[table_id] WHERE [i].[status] = 'A' AND [d].[status] = 'D'; END;
Schema change tracking trigger
-- ============================================= -- Description: Insert trigger's changes to schema change tracking tables -- ============================================= CREATE TRIGGER [trg_triggers_change_track_update] ON [triggers] FOR UPDATE AS -- skip manual objects created through Dataedo application IF EXISTS ( SELECT TOP (1) 1 FROM [INSERTED] WHERE [source] = 'USER' ) BEGIN RETURN; END; -- check if object property change IF EXISTS ( SELECT TOP (1) 1 FROM [inserted] [i] INNER JOIN [deleted] [d] ON [i].[trigger_id] = [d].[trigger_id] WHERE ISNULL([d].[table_id],'') <> [i].[table_id] OR ISNULL([d].[name],'') <> [i].[name] OR ISNULL([d].[before],'') <> [i].[before] OR ISNULL([d].[after],'') <> [i].[after] OR ISNULL([d].[instead_of],'') <> [i].[instead_of] OR ISNULL([d].[on_insert],'') <> [i].[on_insert] OR ISNULL([d].[on_update],'') <> [i].[on_update] OR ISNULL([d].[on_delete],'') <> [i].[on_delete] OR ISNULL([d].[disabled],'') <> [i].[disabled] OR ISNULL([d].[definition],'') <> [i].[definition] OR ISNULL([d].[type],'') <> [i].[type] ) BEGIN UPDATE [triggers_changes] SET [valid_to] = GETDATE() FROM [triggers_changes] [c] INNER JOIN [inserted] [u] ON [c].[table_id] = [u].[table_id] WHERE [valid_to] IS NULL; -- insert changes (before and after values) for trigger - when trigger was updated INSERT INTO [triggers_changes] ([database_id], [trigger_id], [table_id], [name], [before], [after], [instead_of], [on_insert], [on_update], [on_delete], [disabled], [definition], [before_before], [before_after], [before_instead_of], [before_on_insert], [before_on_update], [before_on_delete], [before_disabled], [before_definition], [type], [operation], [valid_from], [update_id] ) SELECT [t].[database_id], [i].[trigger_id], [i].[table_id], [i].[name], [i].[before], [i].[after], [i].[instead_of], [i].[on_insert], [i].[on_update], [i].[on_delete], [i].[disabled], [i].[definition], [d].[before], [d].[after], [d].[instead_of], [d].[on_insert], [d].[on_update], [d].[on_delete], [d].[disabled], [d].[definition], [d].[type], 'UPDATED', [cc].[valid_to], [i].[update_id] FROM [inserted] [i] INNER JOIN [deleted] [d] ON [i].[trigger_id] = [d].[trigger_id] LEFT OUTER JOIN [tables] [t] ON [d].[table_id] = [t].[table_id] OUTER APPLY ( SELECT MAX([valid_to]) AS [valid_to] FROM [triggers_changes] [c] WHERE [c].[trigger_id] = [d].[trigger_id] AND [c].[valid_to] IS NOT NULL ) [cc] WHERE [i].[status] = 'A' AND [d].[status] = 'A' AND (ISNULL([d].[table_id],'') <> [i].[table_id] OR ISNULL([d].[name],'') <> [i].[name] OR ISNULL([d].[before],'') <> [i].[before] OR ISNULL([d].[after],'') <> [i].[after] OR ISNULL([d].[instead_of],'') <> [i].[instead_of] OR ISNULL([d].[on_insert],'') <> [i].[on_insert] OR ISNULL([d].[on_update],'') <> [i].[on_update] OR ISNULL([d].[on_delete],'') <> [i].[on_delete] OR ISNULL([d].[disabled],'') <> [i].[disabled] OR ISNULL([d].[definition],'') <> [i].[definition] OR ISNULL([d].[type],'') <> [i].[type]); END; BEGIN -- insert changes (deleted values) for trigger - when trigger was deleted INSERT INTO [triggers_changes] ([database_id], [trigger_id], [table_id], [name], [before], [after], [instead_of], [on_insert], [on_update], [on_delete], [disabled], [definition], [type], [operation], [valid_to], [update_id] ) SELECT [t].[database_id], [d].[trigger_id], [d].[table_id], [d].[name], [d].[before], [d].[after], [d].[instead_of], [d].[on_insert], [d].[on_update], [d].[on_delete], [d].[disabled], [d].[definition], [d].[type], 'DELETED', GETDATE(), [i].[update_id] FROM [inserted] [i] INNER JOIN [deleted] [d] ON [i].[trigger_id] = [d].[trigger_id] LEFT OUTER JOIN [tables] [t] ON [d].[table_id] = [t].[table_id] WHERE [i].[status] = 'D' AND [d].[status] = 'A'; -- insert changes (updated values) for trigger - when trigger was restored INSERT INTO [triggers_changes] ([database_id], [trigger_id], [table_id], [name], [before], [after], [instead_of], [on_insert], [on_update], [on_delete], [disabled], [definition], [type], [operation], [valid_from], [update_id] ) SELECT [t].[database_id], [i].[trigger_id], [i].[table_id], [i].[name], [i].[before], [i].[after], [i].[instead_of], [i].[on_insert], [i].[on_update], [i].[on_delete], [i].[disabled], [i].[definition], [i].[type], 'ADDED', GETDATE(), [i].[update_id] FROM [inserted] [i] INNER JOIN [deleted] [d] ON [i].[trigger_id] = [d].[trigger_id] LEFT OUTER JOIN [tables] [t] ON [d].[table_id] = [t].[table_id] WHERE [i].[status] = 'A' AND [d].[status] = 'D'; END;
	trg_triggers_Modify	After Insert, Update	Standard insert/update trigger setting last_modification_date, modified by columns
-- ============================================= -- Author: Piotr Kononow -- Create date: 2014-06-18 -- Description: Updates last_modification_date, modified_by columns on insert or update -- ============================================= create TRIGGER [trg_triggers_Modify] ON dbo.triggers AFTER INSERT, UPDATE AS BEGIN UPDATE [triggers] SET last_modification_date = GETDATE(), modified_by = suser_sname() WHERE trigger_id IN (SELECT DISTINCT trigger_id FROM Inserted) END
Standard insert/update trigger setting last_modification_date, modified by columns
-- ============================================= -- Author: Piotr Kononow -- Create date: 2014-06-18 -- Description: Updates last_modification_date, modified_by columns on insert or update -- ============================================= create TRIGGER [trg_triggers_Modify] ON dbo.triggers AFTER INSERT, UPDATE AS BEGIN UPDATE [triggers] SET last_modification_date = GETDATE(), modified_by = suser_sname() WHERE trigger_id IN (SELECT DISTINCT trigger_id FROM Inserted) END

Uses

Name
dbo.triggers (Triggers)
dbo.schema_updates (Imports/Updates)
dbo.tables (Tables and Views)
dbo.trg_triggers_change_track_insert
dbo.schema_updates (Imports/Updates)
dbo.tables (Tables and Views)
dbo.triggers_changes
dbo.trg_triggers_change_track_update
dbo.tables (Tables and Views)
dbo.triggers_changes
dbo.trg_triggers_Modify
dbo.triggers (Triggers)

Used by

Name
dbo.triggers (Triggers)
dbo.trg_triggers_Modify
dbo.triggers_changes

Exported: 2018-12-06 15:15, Last imported: 2018-11-21 15:11