use PROFIX
GO

DROP TRIGGER IF EXISTS TR_INSERT_TABLE_A;
DROP TRIGGER IF EXISTS TR_UPDATE_TABLE_A;

DROP TRIGGER IF EXISTS TR_INSERT_TABLE_B;
DROP TRIGGER IF EXISTS TR_UPDATE_TABLE_B;

DROP TABLE IF EXISTS TABLE_A;
DROP TABLE IF EXISTS TABLE_B;
DROP TABLE IF EXISTS RES_TABLE;

CREATE TABLE TABLE_A
(  
  ID TINYINT NOT NULL IDENTITY(1,1),
   CONSTRAINT PK_TABLE_A PRIMARY KEY(ID),
  FIELD2 VARCHAR(100)NOT NULL,
  FIELD3 VARCHAR(100)NOT NULL
) ;
CREATE TABLE TABLE_B
(
  ID TINYINT NOT NULL IDENTITY(1,1),
   CONSTRAINT PK_TABLE_B PRIMARY KEY(ID),
  FIELD5 VARCHAR(100)NOT NULL,
  FIELD6 VARCHAR(100)NOT NULL
    
);
CREATE TABLE RES_TABLE
(
  TABLE_NAME VARCHAR(100) NOT NULL,
  ID TINYINT NOT NULL,
  OPERATION VARCHAR(20)NOT NULL
)
GO
------------------------------------------------------------
CREATE TRIGGER TR_INSERT_TABLE_A
ON [dbo].[TABLE_A] AFTER INSERT
AS
 BEGIN
  SET NOCOUNT ON;
  INSERT [dbo].[RES_TABLE]([TABLE_NAME],[ID],[OPERATION])
   SELECT 'TABLE_A',I.ID,'INSERT'
    FROM INSERTED AS I
 END
GO

CREATE TRIGGER TR_UPDATE_TABLE_A
ON [dbo].[TABLE_A]AFTER UPDATE
AS
 BEGIN
  SET NOCOUNT ON;
  INSERT [dbo].[RES_TABLE]([TABLE_NAME],[ID],[OPERATION])
   SELECT 'TABLE_A',I.ID,'UPDATE'
    FROM inserted AS I
	JOIN DELETED AS D ON I.ID=D.ID
 END
GO
------------------------------------------------------
CREATE TRIGGER TR_INSERT_TABLE_B
ON [dbo].[TABLE_B] AFTER INSERT
AS
 BEGIN
  SET NOCOUNT ON;
  INSERT [dbo].[RES_TABLE]([TABLE_NAME],[ID],[OPERATION])
   SELECT 'TABLE_B',I.ID,'INSERT'
    FROM INSERTED AS I
 END
GO

CREATE TRIGGER TR_UPDATE_TABLE_B
ON [dbo].[TABLE_B]AFTER UPDATE
AS
 BEGIN
  SET NOCOUNT ON;
  INSERT [dbo].[RES_TABLE]([TABLE_NAME],[ID],[OPERATION])
   SELECT 'TABLE_B',I.ID,'UPDATE'
    FROM inserted AS I
	JOIN DELETED AS D ON I.ID=D.ID
 END
GO
--------------------------------------------------
INSERT [dbo].[TABLE_A]([FIELD2],[FIELD3])
VALUES('IVANOFF','IVAN'),('SIDOROFF','SIDOR');

INSERT [dbo].[TABLE_B]([FIELD5],[FIELD6])
VALUES('PETROFF','PETR'),('TRUMP','DONALD');

UPDATE [dbo].[TABLE_A]SET
  [FIELD2]='WASHINGTON'
  WHERE ID=2;

UPDATE [dbo].[TABLE_B] SET
 [FIELD5]='HAMILTON'
 WHERE ID=2;