Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

what is a trigger and types of triggers

Answer Posted / anitha

A trigger is a set of actions that are run automatically when a specified change operation is performed on a specified table. The change operation can be an SQL INSERT, UPDATE, or DELETE statement, or an insert, update, or delete high level language statement in an application program
types of triggers.
• Before delete trigger
• Before insert trigger
• Before update trigger
• After delete trigger
• After insert trigger
• After update trigger
• Read only trigger (external trigger only)

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?

1107


can all users have the privilage to use the sql statement select * (dml)?

1119


What is the information associated with sysibm.syslinks table?

1077


What is a page in db2?

991


What is check constraint in db2?

1023


What does sqlcabc has?

1006


What is package in db2 mainframe?

930


What is query_cache_limit?

936


Discuss about db2 bind?

1056


How do I start db2 in windows?

1036


What is clone table?

1007


File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

2880


Is db2 free?

1044


How to restart a DB2 program?

1835


What are host variables in db2?

1001