Click here to Skip to main content
15,888,461 members
Search within:


After Creating Triggers two tables will created automatically,What are those tables?
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
SQL
After Creating Triggers two tables will created automatically,What are those tables?
Posted
Add a Solution
Comments
Kornfeld Eliyahu Peter 15-Dec-14 5:06am    
Ask the one created the trigger!
Ankur\m/ 15-Dec-14 5:27am    
Homework / Interview question?
[no name] 15-Dec-14 5:40am    
2 temporary table are created after trigger fires .New record and old records are Stored in 2 temp tables . we can get old fields by (eg: :old.id ) and new fields by (eg: :new.id ).

ur questions is not clear .try to write questions in proper way..thanks 4 ur downvoting..

2 solutions

Do you mean below two tables?
1.Inserted
2.Deleted
 
Share this answer
 
Posted
Comments
Harsh Athalye 15-Dec-14 7:16am    
why downvote?
If you have implemented any trigger for any Tables then,
Whenever you insert a record into a table, that record will be in the INSERTED Magic table.
Whenever you update the record in that table, that existing record will be in the DELETED Magic table and the modified new data with be in the INSERTED Magic table.
Whenever you delete a record in that table, that record will be in the DELETED Magic table only.
These magic tables are used inside the Triggers for tracking the data transaction.
 
Share this answer
 
Posted
Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month
Related Questions
Create table in trigger.
How to create a Trigger?
How to insert rows to table ( control a condition by trigger)
Create tables automatic
sql server trigger to insert automatic on other database table
Phpmyadmin: error creating table
Create trigger bond to multiple tables
Create Trigger in mysql
create one table or two table?
CREATE one trigger For two different database

Advertise
Privacy
Cookies
Terms of Use
Last Updated 15 Dec 2014
Layout: fixed | fluid
Copyright © CodeProject, 1999-2024
All Rights Reserved.

Web03 2.8:2024-04-02:1

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900