I want to create a trigger in my database to track the changes in some of my more important tables. I would like to be able to find out what type of action was taken( e.g. UPDATE DELETE or INSERT). Is there any sort of variable or function I could include in my trigger to return this information.
Also in a related thought. I know a trigger has to be tied to either an insert or update event. So I'm thinking for each table I will have to have two triggers (one for each event). Is this true or is there a way to only have one trigger per table. If it isn't clear, this is my first time working with triggers.
Thanks for any help in advance.
Also in a related thought. I know a trigger has to be tied to either an insert or update event. So I'm thinking for each table I will have to have two triggers (one for each event). Is this true or is there a way to only have one trigger per table. If it isn't clear, this is my first time working with triggers.
Thanks for any help in advance.