what is a trigger?

what is main difference between ddl trigger and dml trigger?

DDL tiggers are operate on Create, Drop,Alter and are useful to perform administrative tasks and enforce business rules.

DMl triggers are operate on Insert,Update,Delete and they are useful to enforce business rules and maintain data integrity when dml commands operate on tables(views).

A DML trigger is a stored procedure that goes into effect when you insert, delete, or update data in a table. You can use triggers to perform a number of automatic actions, such as cascading changes through related tables, enforcing column restrictions, comparing the results of data modifications, and maintaining the referential integrity of data across a database.

DML Triggers are automatic. They work no matter what caused the data modification. A trigger is specific to one or more of the data modification operations, update, insert, and delete and is executed once for each SQL statement.

For example, to prevent users from removing any publishing companies from the publishers table, you could use this trigger:


Thanks
Shobi

1.DDL triggers fire on execution of the dependent DDLs ,like create,alter or drop.

2.DMl triggers fire on execution of the dependent DMLs like insert,update,delete .

A trigger is a set of actionsthat are executed automatically whenever a specified event occurs to a specified base table. the event can be an insert,update or delete operation.

or we can say that a trigger is a set of actions that run automatically when a specified change or read operation is performed on a specified physical database file...

A trigger is a SQL procedure that initiates an action when an event (INSERT, DELETE or UPDATE) occurs.
Triggers are stored in and managed by the DBMS.Triggers are used to maintain the referential integrity of data by changing the data in a systematic fashion. A trigger cannot be called or executed.

DDL Triggers r operate on Crete,Drop,Alter.
DML Triggers r operate on Insert,Update,Delete.

Trigger is a automatic action which can fire when an action is performed.

Who we can know weather Trigger is fired or not.

Trigger is a event based action.
whenever we perform insert,update and delete actions then it will fires automatically.

Triggers are the event based actions which are fired whenever the event on DDL and DML commands takes place

trigger mainly used to implement business rules, we can perform only DML operations in trigger, trigger is implicitly called by the database

Triggers allow us to execute a batch of sql code when either an insert, update or delete command is executed against a specific table. Triggers fires automatically whereever there is any insert or delete based on your trigger. There is two types of triggers ddl trigger & dml triggers ddl trigger ---it stands for data defination language trigger. Triggers that fires on create,alter or drop statement is execute. Dml trigger ----it stands for data manipulation language trigger. Triggers that fires when there is any insert,delete or update trigger fires.