There are two Magic Tables in SQL Server: 

1. INSERTED:- This table is created when a trigger is created on a table for Insert and Update. 

1. DELETED:- This table is created when a trigger is created on a table for Update and Delete.