Deleted table in sql trigger

CREATE TRIGGER tr_audit_delete
ON dbo.customers
AFTER DELETE
AS
BEGIN
    SELECT * FROM DELETED;
END
/*
If you issue a DELETE statement that deletes three rows from the customers
table, the trigger will execute and the SELECT statement will return those 
three rows. If you issue a DELETE statement that deletes no rows from the 
customers table, the trigger will still execute, but the SELECT statement 
will return no rows.

It's important to note that the DELETED table is a temporary, in-memory table 
that is only available within the context of the trigger. It is not a real 
database table, and it is not persisted to disk. The DELETED table is 
automatically created and populated when a trigger is executed, and it is 
automatically dropped when the trigger completes.
*/

Source: youtube.com

Similar codes

1 vote170 views1 answer
Insert pg result of select
SQL
5 votes123 views1 answer
Update sql user password
SQL
0 vote141 views1 answer
Postgresql replace html tags from string
SQL
0 vote130 views1 answer
Turnicate in mysql
SQL
3 votes130 views1 answer
Oracle transaction commit rollback example
SQL
0 vote117 views1 answer
Sql query to select records entered in last 24 hours
SQL
14 votes134 views1 answer
Oracle new column
SQL
0 vote130 views1 answer
Sql server select ignore dupplicates
SQL
0 vote119 views1 answer
Remove binlog mysql
SQL
-1 vote126 views1 answer
Ssql to lowercqse
SQL