Jul 15 2008 01:00 PM 3667 8 After trigger Minakshi Sur Is there any reason for which we cannot use After trigger with a view? psingla Profile Answers by psingla Questions by psingla Mar 16th, 2010 A after trigger gets fired whenever there is any insert/update/delete happens in the table on which the trigger is defined.But the view is just a definition rather than an actual table so insert/updat... pprasad_ktda Profile Answers by pprasad_ktda Questions by pprasad_ktda Sep 4th, 2009 In a view if composite primary key is present than "After Trigger" cannot be defined. Answer Question Select Best Answer
Jul 15 2008 01:00 PM 3667 8 After trigger Minakshi Sur Is there any reason for which we cannot use After trigger with a view? psingla Profile Answers by psingla Questions by psingla Mar 16th, 2010 A after trigger gets fired whenever there is any insert/update/delete happens in the table on which the trigger is defined.But the view is just a definition rather than an actual table so insert/updat... pprasad_ktda Profile Answers by pprasad_ktda Questions by pprasad_ktda Sep 4th, 2009 In a view if composite primary key is present than "After Trigger" cannot be defined. Answer Question Select Best Answer
psingla Profile Answers by psingla Questions by psingla Mar 16th, 2010 A after trigger gets fired whenever there is any insert/update/delete happens in the table on which the trigger is defined.But the view is just a definition rather than an actual table so insert/updat...
pprasad_ktda Profile Answers by pprasad_ktda Questions by pprasad_ktda Sep 4th, 2009 In a view if composite primary key is present than "After Trigger" cannot be defined.