If you're using ERwin, you can use %TableName within the
If you're not, the following sample should help:
create table TestTable (keycol int PRIMARY KEY, attcol int)
create trigger iud_TestTable
for insert, update, delete
select p.[name] AS TableName
from sysobjects p
join sysobjects c
on p.id = c.parent_obj
where c.id = PROCID
update TestTable set attcol = 0
>does anyone know how to obtain a trigger's owner table
>within the trigger.
>I want to generically get the name of the table that owns
>the trigger, but without making ...