answersLogoWhite

0


Want this question answered?

Be notified when an answer is posted

Add your answer:

Earn +20 pts
Q: How many trigger can have on one table?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

Why need trigger in sql server 2000?

Why not trigger in SQL Server 2000? I think you need to understand what the definition of a database trigger is in this case. A database trigger is simply code that the database system will trigger when a certain event occurs. The classic example is having a multi-table order system that has the order # in one table and parts ordered linked in a orderDetails table, with the order pointing to the product description in a separate table. So a useful trigger would be that when an order gets deleted from the order table, all the matching order detail rows in the orderDetails table get deleted. Hope this helps.


What is a Trigger in MySQL Define different types of Trigger?

A trigger is a named database object that is associated with a table, and that activates when a particular event occurs for the table. Some uses for triggers are to perform checks of values to be inserted into a table or to perform calculations on values involved in an update. A trigger is associated with a table and is defined to activate when an INSERT,DELETE, or UPDATE statement for the table executes. A trigger can be set to activate either before or after the triggering statement. For example, you can have a trigger activate before each row that is deleted from a table or after each row that is updated. Sender : Yugant khokhar


What is triggers in plsql?

a trigger is user defined constraint. A trigger is code that executes based upon an event. A trigger is mostly used on a table and can execute before or after the event. The event that triggers act upon are inserts, updates and deletes on the table or rows in the table.


What are the Different types of relationship in a database?

There are mainly three types of relationships in database . These are One to One , One to Many , Many to Many. One to one relationship can be seen as relationship between husband and wife , one to many relationship can be seen as a relationship between a college and students.


How is a fully-automatic firearm different from a semi-automatic firearm?

Semi is one trigger pull one bullet Fully is one trigger pull many bullets


What relationship to use if you have one record in a table is related to many records in another table.?

One-to-many relationship


Can You Write Trigger in Stored Procedures?

A trigger is a stored procedure. It is a special stored procedure that runs in response to some defined event, such as an insert into a table.


What trigger anger?

There are many things that trigger anger. It varies from person to person. For example: a dirty house may trigger anger in one person, and not bother another personal at all.


What are one to many and many to many Relationship in database?

Relationships happen between two tables. One to Many means that one objects (called tuples, or rows) of Table A is related to one or more objects in Table B. For example, if a doctor can work only in one hospital, and we have a table of hospitals and a table of doctors, Hospitals has a One to Many relationship with Doctors, because for each hospital you will have one or more doctors working at it. Many to Many means that for each object in Table A, one or more objects in Table B are associated, and viceversa. In the example, if doctors are allowed to work in different hospitals, the table Hospitals and the table Doctors have a Many to Many relationship. Now, how to implement this in a relationship DB, that is another question.


How many pages does The Trigger have?

The Trigger has 550 pages.


What is mean by trigger?

it s an stored procedures....it s an statements..that goes into effect when you modify data in a specified table using one or more data modification operations: UPDATE, INSERT,or DELETE.a trigger is a set of Structured Query Language (SQL) statements that automatically "fires off" an action when a specific operation, such as changing data in a table, occurs.


Where can one purchase custom table pads?

One can purchase custom table pads in many different places. Some places where one can buy custom table pads are Custom Table Pads, Pioneer Table Pad, and Table Pad Factory.