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 vote249 views1 answer
Selects all the columns from the sailors table
SQL
0 vote266 views3 answers
Sql all columns
SQL
0 vote264 views1 answer
Database timezone
SQL
14 votes277 views1 answer
Sql value of string
SQL
0 vote275 views1 answer
Sqlcmd no headers
SQL
4 votes277 views1 answer
Group by mysql and concatenate string
SQL
10 votes245 views1 answer
Oracle dependency
SQL
1 vote281 views2 answers
Group_concat limit mysql
SQL
3 votes256 views1 answer
Oracle undo tablespace list by user
SQL
0 vote260 views1 answer
Mysql command line ubuntu
SQL