-
Junior Member
what is a trigger?
what is main difference between ddl trigger and dml trigger?
-
Expert Member
Re: what is a 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).
-
Junior Member
Re: what is a trigger?
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
Last edited by shobi_at; 12-20-2007 at 01:31 AM.
-
Re: what is a trigger?
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 .
-
Junior Member
Re: what is a trigger?
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...
-
Junior Member
Re: what is a trigger?
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.
-
Contributing Member
Re: what is a trigger?
Trigger is a automatic action which can fire when an action is performed.
-
Junior Member
Re: what is a trigger?
Who we can know weather Trigger is fired or not.
-
Junior Member
Re: what is a trigger?
Trigger is a event based action.
whenever we perform insert,update and delete actions then it will fires automatically.
-
Junior Member
Re: what is a trigger?
Triggers are the event based actions which are fired whenever the event on DDL and DML commands takes place
-
Junior Member
Re: what is a trigger?
trigger mainly used to implement business rules, we can perform only DML operations in trigger, trigger is implicitly called by the database
-
Junior Member
Re: what is a trigger?
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules