What is Magic Table in SQL Server

The tables 'INSERTED', 'UPDATED' and 'DELETED' are called Magic Table of SQL Server. We can't see the table in SQL Server db. It's created automatically and manage by SQL Server.

Magic table contain the recent Inserted, Updated and deleted data.

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

-- =============================================

-- Author:           <Author,,Anil Singh>

-- Create date: <05-09-2014,,>

-- =============================================

CREATE TRIGGER MAGICTABLEDATA

   ON [dbo].[Users]

   AFTER INSERT,DELETE,UPDATE

AS

BEGIN

       -- SET NOCOUNT ON added to prevent extra result sets from

       -- interfering with SELECT statements.

       SET NOCOUNT ON;

       -- Insert statements for trigger here

       SELECT * FORM INSERTED

       SELECT * FORM DELETED

END

GO