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

2 votes361 views2 answers
Mysql on duplicate key update get value from values
SQL
-1 vote331 views1 answer
Module operator in oracle sql
SQL
0 vote311 views1 answer
Sql server select ignore dupplicates
SQL
0 vote415 views2 answers
Insert data into multiple tables mysql
SQL
0 vote359 views1 answer
Error: SAP DBTech JDBC: [258]: insufficient privilege: Detailed info for this error can be found with guid '87813FAA56439F48BD60812F3EBEC5A4'
SQL
0 vote323 views1 answer
Create table sql generator
SQL
0 vote314 views1 answer
Mysql command line ubuntu
SQL
1 vote327 views1 answer
Snowflake rename column name
SQL
0 vote319 views1 answer
"SET SQL_AUTO_IS_NULL = 0" query problem
SQL
2 votes347 views2 answers
Postgres add column integer
SQL