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

0 vote214 views1 answer
Formatting code with SQL Developer
SQL
1 vote232 views2 answers
Snowflake alter column data type
SQL
0 vote241 views2 answers
Sql auto update dupdated_at
SQL
0 vote220 views1 answer
Count number of entires by months sql
SQL
8 votes240 views6 answers
Sql insert
SQL
0 vote210 views1 answer
Transalations from sql to Linq count and group by
SQL
0 vote210 views1 answer
Can we rollback deleted data in sql
SQL
0 vote224 views1 answer
Cannot create a JSON value from a string with CHARACTER SET 'binary'.
SQL
2 votes252 views1 answer
Datefromparts mssql
SQL
3 votes233 views2 answers
SqlMessage: "Host '192.168.64.1' is not allowed to connect to this MariaDB server
SQL