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

5 votes233 views3 answers
Mysql extract month from date
SQL
0 vote261 views1 answer
Joomla execute raw sql
SQL
0 vote272 views1 answer
SQLSTATE[01000]: Warning: 1265 Data truncated for column 'job_type' at row 1 (SQL: insert into
SQL
9 votes240 views3 answers
Mysql show table column full description
SQL
0 vote245 views1 answer
Call object contructor and call methods of object
SQL
2 votes237 views5 answers
SQL trigger
SQL
3 votes238 views1 answer
Oracle list user grants
SQL
0 vote171 views1 answer
Mitigation of sql injection
SQL
2 votes224 views1 answer
Query to find table size in oracle 12c
SQL
2 votes212 views1 answer
Mysql list users on ubuntu
SQL