|
-
Re: TRIGGER
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.
Best wishes!
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.
For Ex:
Delete from another_table where collumn_another_table =
collumn_table_of_trigger;
How can i reference the collumn?
Thanks.......
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|