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 vote181 views1 answer
Sql create table with references not primary key
SQL
16 votes232 views1 answer
Mysql mediumint max value
SQL
1 vote182 views1 answer
Insert column after column mysql
SQL
0 vote204 views1 answer
Postgresql inheritance
SQL
0 vote177 views1 answer
NLS_NCHAR_CHARACTERSET
SQL
1 vote181 views1 answer
DoVerify() must be an instance of Lcobucci\\JWT\\Signer\\Key
SQL
1 vote161 views1 answer
Mysql average of multiple columns
SQL
0 vote204 views1 answer
Postgres duplicate database in same server while other session is using source database
SQL
0 vote195 views1 answer
PostgreSQL types and C# types
SQL
4 votes171 views2 answers
Oracle unliock account
SQL