What are Magic Table?

Categories >> Software >> Databases >> SQL Server
Suggest New Category

Question Posted / dinesh gupta

34 Answers
77659 Views
3i Infotech, Digiweb, Evalueserve, NIIT, PL, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What are Magic Table?..

Answer / anilkumar,bijapur

The magic table is when we "INSERT" a table values that
values stored into table it's one magic
and another magic is "DELETE" when we DELETE the values in
a table the compiler delete the values whatever you are
stored

@)INSERT

@)DELETE

Is This Answer Correct ?

8 Yes

3 No

What are Magic Table?..

Answer / manish kumar

Magic tables are created when data is inserted or updated
in the normal tables. They get deleted when the commit is
done. They are used for the auditing purposes.
They are useful in keeping track of the insertion and
updation on the database.

Is This Answer Correct ?

7 Yes

3 No

What are Magic Table?..

Answer / puneet sharma

INSERTED and DELETED tables known as MAGIC
TABLES.BECAUSE IN BOTH THE CASES TRIGGER FIRES AND
TEMPORARILLY STORE INSERTED AND DELETED VALUES
RESPECTIVELLY.

Is This Answer Correct ?

5 Yes

1 No

What are Magic Table?..

Answer / ajay kumar

Whenever a trigger is fired in response to the
INSERT,DELETE,Or UPDATE statement the SQL SERVER creates
two temporary tables, Called Magic Table. The Magic Table
called inserted or deleted. The magic table conceptual
tables are similar in structure to the table on which thw
trigger is difined.

Is This Answer Correct ?

4 Yes

1 No

What are Magic Table?..

Answer / danish aleem

An implicit trigger is fired when ever we insert, update or delete, then the two temporary tables are created i.e.insert and delete. So these temporary tables are termed as MAGIC TABLES.

* These are named as MAGIC because they are removed automatically when the specified query is committed.

Is This Answer Correct ?

3 Yes

0 No

What are Magic Table?..

Answer / sharda prasad shukla

MAGIC TABLES NOTHING BUT INSERTED AND DELETED WHICH ARE
TEMPORARY OBJECTS CREATED BY SERVER INTERNALLY TO HOLD
RECENTLY INSERTED VALUES IN THE CASE OF INSERT,TO HOLD
RECENTLY DELETED VALUES IN THE CASE OF DELETE,TO HOLD
BEFORE UPDATING VALUES OR AFTER UPDATING VALUES IN THE CASE
OF UPDATE.

Is This Answer Correct ?

3 Yes

1 No

What are Magic Table?..

Answer / johnny

Magic? I'm still waiting for the rabbit to appear...

Is This Answer Correct ?

2 Yes

0 No

What are Magic Table?..

Answer / digvijay kumar singh

Magic table is Temporary type table. it is created when
trigger perform the insert,delete and update action. trigger
have two type magic table:-
1:- inserted table.
2:- deleted table.

when trigger perform the insert and update action on table
then trigger used the Inserted magic table and deleted magic
table used at deletion time.

i hope you will understand..................

Is This Answer Correct ?

2 Yes

0 No

What are Magic Table?..

Answer / sabahuddin

Usually Inserted and Deleted Tables are called Magic Tables.Magic Tables does not contain the information about

the Columns of the DataType text,ntext or image.These are maintained by SQL Server for internal processing whenver an update,insert,Delete occur on table.However we can refer these tables in Triggers.

Whenever an updated table statement is fired SQL Server Maintains the original row before updation in a deleted table and New(Updated) row in inserted table.

Is This Answer Correct ?

2 Yes

0 No

What are Magic Table?..

Answer / sabahuddin

Usually Inserted and Deleted Tables are called Magic Tables.Magic Tables does not contain the information about
the Columns of the DataType text,ntext or image.These are maintained by SQL Server for internal processing whenver an update,insert,Delete occur on table.However we can refer these tables in Triggers.
Whenever an updated table statement is fired SQL Server Maintains the original row before updation in a deleted table and New(Updated) row in inserted table.

Is This Answer Correct ?

1 Yes

0 No

Post New Answer