Thread: What is trigger?

I know that A trigger is a special kind of stored procedure that is invoked whenever an attempt is made to modify the data in the table it protects. Modifications to the table are made ussing INSERT,UPDATE,OR DELETE statements.

For example, if you have a table with a field that contains the date this record has been modified, you could set a trigger on updates and inserts that will set this field to the current date so you wont have to handle this field in your application code.

Triggers are used to enforce data integrity and business rules such as automatically updating summary data. It allows to perform cascading delete or update operations. If constraints exist on the trigger table,they are checked prior to the trigger execution. If constraints are violated statement will not be executed and trigger will not run.Triggers are associated with tables and they are automatic . Triggers are automatically invoked by SQL SERVER. Triggers prevent incorrect , unauthorized,or inconsistent changes to data.

Triggers are programs that execute in acknowledgment to changes in table abstracts or assertive database events. There is a predefined set of contest that can be "hooked" with a trigger, enabling you to accommodate your own processing with that of the database.

Triggers are the programs that is used to store the procedure.. Trigger is part of mysql...

Trigger is a SQL procedure that initiates an action, when an event (INSERT, DELETE or UPDATE) occurs.