Subject | get table name in trigger |
---|---|
Author | orhanturhan |
Post date | 2009-08-24T09:44:57Z |
for example
CREATE OR ALTER TRIGGER CUSTOMER_BI FOR CARI
ACTIVE BEFORE INSERT POSITION 0
as
begin
...........
insert into logs
(table_name, event_time)
values
(????????????? ,current);
...........
end;
i want to ????????????=trigger table name
if table name is Customer then ????????????=Customer
else
if table name is Items then ????????????=Items
i hope tell myself.
CREATE OR ALTER TRIGGER CUSTOMER_BI FOR CARI
ACTIVE BEFORE INSERT POSITION 0
as
begin
...........
insert into logs
(table_name, event_time)
values
(????????????? ,current);
...........
end;
i want to ????????????=trigger table name
if table name is Customer then ????????????=Customer
else
if table name is Items then ????????????=Items
i hope tell myself.