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

6 votes141 views2 answers
Psql load dump
SQL
0 vote137 views1 answer
Postgresql regular expression special characters
SQL
-1 vote134 views2 answers
SQL SELECT TOP Equivalent in oracal
SQL
13 votes165 views3 answers
List all the tables in sql
SQL
24 votes132 views4 answers
How to add column sql
SQL
0 vote143 views1 answer
SQL SERVER SELECT BETWEEN DATETIME
SQL
1 vote165 views1 answer
Sql select sum group by id laravel
SQL
2 votes138 views1 answer
Mysql last 7 days including today
SQL
1 vote124 views1 answer
Sql Split string function
SQL
2 votes145 views1 answer
Sqlite insert if not exists
SQL