Triggers concept

Question

Hi friends..... What are triggers? How to invoke a trigger on demand? Thanks....

Satyapriya Nayak · Answer

Hi Vikas, Normal 0 MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable{mso-style-name:"Table Normal";mso-tstyle-rowband-size:0;mso-tstyle-colband-size:0;mso-style-noshow:yes;mso-style-parent:"";mso-padding-alt:0in 5.4pt 0in 5.4pt;mso-para-margin:0in;mso-para-margin-bottom:.0001pt;mso-pagination:widow-orphan;font-size:10.0pt;font-family:"Times New Roman";} Triggers are special kind of stored procedures that get executed automatically when an INSERT, UPDATE or DELETE operation takes place on a table. Triggers cannot be invoked on demand. They get triggered only when an associated action (INSERT, UPDATE and DELETE) happens on the table on which they are defined. Triggers are generally used to implement business rules, auditing. Triggers can also be used to extend the referential integrity checks, but wherever possible, use constraints for this purpose, instead of triggers, as constraints are much faster Thanks

Vikas Mishra · Answer

Thanks.........

Triggers concept

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (2)