what is an index in sql server

Triggers
A trigger is an object that exists only within the framework of a table. Triggers are pieces of logical code
that are automatically executed when certain things, such as inserts, updates, or deletes, happen to your
table.