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

1 vote268 views1 answer
Mysql server does not start mac
SQL
150 votes532 views10 answers
Grepper
SQL
1 vote265 views1 answer
SQLSTATE[HY000] [2002]
SQL
0 vote416 views1 answer
Sql developer export connections
SQL
0 vote290 views1 answer
Power bi find all ids not in other tables
SQL
1 vote285 views2 answers
Sql left characters
SQL
1 vote284 views1 answer
Create new table in SQL from old table with data
SQL
8 votes273 views1 answer
Alter tablespace add datafile
SQL
29 votes285 views5 answers
Mysql show table structure
SQL
0 vote279 views1 answer
Sql last 7 days
SQL