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 vote184 views1 answer
Enable Rabbitmq management plugin
SQL
2 votes218 views2 answers
Sql query to list all tables in a database sql server
SQL
0 vote177 views1 answer
Lost connection to mysql
SQL
12 votes182 views4 answers
Mysql ifnull
SQL
6 votes141 views2 answers
Spring data jpa application.properties mysql
SQL
0 vote191 views1 answer
Show table details postgresql
SQL
2 votes185 views1 answer
Delete all value query
SQL
1 vote228 views1 answer
Float precision in psql
SQL
0 vote179 views1 answer
Firebase sql
SQL
0 vote184 views1 answer
Get time component of datetime sql
SQL