Sorry, I don't know, but Why would you want to do that, the reference between the tables is not variable, it is not based on what column is modified, the reference existed before, so the trigger must be fixed.
Hey, I am sure you are talking about trigger on view !!!
First of all you have to create view as
select t1.*,t2* from t1,t2
and then create 'INSTEAD OF TRIGGER' on view for the column are you interesting in.
Originally posted by margraf No, i don't want delete just a collumn. I want to delete a row from another table but i have to reference a collumn for this table.
Delete from another_table where collumn_another_table =