answersLogoWhite

0

Database trigger is a procedural code that occurs in response to an event of a table of a database. for ex if any row is added in employee table, new records should also be added in salaries table.

User Avatar

Wiki User

12y ago

What else can I help you with?

Related Questions

What is trigger in oracle?

A trigger is executed automatically when database modification done.


What are the components of relational database?

Table, index, trigger and column Table, index, trigger and column


What is a trigger in dbms?

Trigger is a statement that is automatically executed by the system as a side effect of a modification to the database. Several existing systems have their own non standard trigger functions. For a trigger we need to specify the condition under which the trigger is executed.


What is meant by the term trigger?

when medicine gets to it. Triggers it


What is the definition of tender?

What is meant by tender client database


Why need trigger in sql server 2000?

Why not trigger in SQL Server 2000? I think you need to understand what the definition of a database trigger is in this case. A database trigger is simply code that the database system will trigger when a certain event occurs. The classic example is having a multi-table order system that has the order # in one table and parts ordered linked in a orderDetails table, with the order pointing to the product description in a separate table. So a useful trigger would be that when an order gets deleted from the order table, all the matching order detail rows in the orderDetails table get deleted. Hope this helps.


What is Database triggers in sql?

A database trigger is an action that the database management software will perform automatically when a preset list of conditions are met. Different database vendors have different mechanisms in place for the declaration of triggers, but the principles remain the same.


What is trigger in DBMS?

A trigger is a special kind of stored procedures that automatically executes when an event occurs in the database server. Insert, update and delete are called as events.


What is the trigger?

A trigger is nothing but a database event. It is implicitly evoked whenever a database event like insert, update, delete, shutdown, etc occurs. There are 12 different types of database triggers. They are combintion of the following 1. after, before 2. insert, update, delete 3. row, statement i.e. 2*3*2 = 12 types of database triggers There is an 'instead of' triggers for views.


What is use of database trigger?

A database trigger is a piece of stored procedure code that runs in response to a specified event. The most common use is during DML, to track changes, enforce complex constraints, limit access to data or limit changes to data. The possibilities are endless, but you need to be careful to not do too much in a trigger, as that can degrade query performance.


What is meant by key in database?

A key is a unique part of the record that is used to index.


Relationship between a database and a table?

A table is contained within the database and consists of columns and rows. A table is meant to store data and, in relational databases, are related to other tables within the same database.