What is Trigger in sql?

Hi,
i just want some information about the trigger in sql.

Triggers are stored procedures created in order to enforce integrity rules in a database. A trigger is executed every time when database modification done.
Triggers are executed automatically on occurance of one of the data-modification operations.
A trigger is a database object directly associated with a particular table. It fires whenever a specific statement/type of statement is issued against that table. The types of statements are insert,update,delete and query statements. Basically, trigger is a set of SQL statements A trigger is a solution to the restrictions of a constraint.

Thanks,

but this information is very short , i want some brief information about the trigger.
will u please help me for this?

See This : http://forums.techarena.in/software-...nt/1069017.htm it will help you.