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 vote231 views3 answers
Mysql CAST(amount as float)
SQL
2 votes193 views1 answer
Alter table add column and foreign key mysql
SQL
0 vote192 views2 answers
T sql null or empty string
SQL
-1 vote205 views1 answer
Count occurrences sql
SQL
5 votes238 views2 answers
Oracle show procedures
SQL
0 vote262 views1 answer
Mac os zsh: command not found: mysql
SQL
0 vote219 views1 answer
Mysql sleep connections
SQL
0 vote193 views1 answer
Drop all tables db2
SQL
0 vote192 views1 answer
Top frequency in sql server
SQL
0 vote185 views1 answer
Sql menampilkan data tabel
SQL