Triggers use in a Table

Question

Hi Friends I want to know that in a single table how many maximum number of triggers can be used ?

Jignesh Trivedi · Answer

hi Manish Maximum number of triggers Limited by number of DataBase objects in a database. Database objects include objects such as tables views stored procedures user-defined functions triggers rules defaults and constraints. The sum of the number of all objects in a database cannot exceed 2147483647 . Please Refer http://msdn.microsoft.com/en-us/library/ms143432.aspx hope this will help you.

Satyapriya Nayak · Answer

Hi Manish Please refer the below links http://forums.asp.net/t/1358067.aspx http://iniaz.com/index.php/oracle-faq/3-Database/92-what-is-the-maximum-number-of-triggers-can-apply-to-a-single-table-.pdf Thanks