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 votes309 views3 answers
Replace null in sql
SQL
8 votes323 views1 answer
Oracle all_source package body
SQL
0 vote411 views1 answer
1422: Explicit or implicit commit is not allowed in stored function or trigger
SQL
10 votes360 views5 answers
Create table mysql query
SQL
52 votes571 views6 answers
Rename column sql
SQL
2 votes329 views2 answers
Sql strip non alphanumeric characters
SQL
0 vote343 views1 answer
Coalesce for comma separated in sql server
SQL
0 vote326 views1 answer
Oracle running queries sql
SQL
0 vote342 views1 answer
Hour differeence in mysql
SQL
0 vote317 views1 answer
Mysql workbench procedure
SQL