How many trigger we can create on a table? How many column we can create in a table?

Questions by ily_saravanan   answers by ily_saravanan

Showing Answers 1 - 23 of 23 Answers

kiran

  • Nov 3rd, 2006
 

We can create any number of trigger on a table.

Trigger is nothing but, "Set of statements which is executed automatically when ever we perform any operation performed on a database like inserting a row, deleting a row, or updating a value".

  Was this answer useful?  Yes

Swapna Gentyala

  • Nov 3rd, 2006
 

Hi,

You can create 12 triggers on a table.

Maximum number of columns in one table - 3398

Oracle: Maximum number of columns in one table - 1000. Up to 32 columns    in index key.

  Was this answer useful?  Yes

Murali Krishna Nekkalapudi

  • Nov 25th, 2006
 

In all we can write as many 15 triggers on a table without contradiction.

  Was this answer useful?  Yes

nagaraj

  • Dec 1st, 2006
 

You can create 1024 columns in the given table in SQL Server

  Was this answer useful?  Yes

Atul Trikha

  • Feb 5th, 2007
 

Maximum No of Triggers=300Maximum No of Columns=8000

  Was this answer useful?  Yes

Janmejay Rout

  • Jul 13th, 2015
 

Hi,
You can create 12 triggers on a table.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions