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 vote215 views1 answer
Mysql pv progres
SQL
1 vote195 views2 answers
Sql groub by count
SQL
1 vote201 views1 answer
Host 127.0 0.1 is not allowed to connect to this mysql server
SQL
1 vote302 views4 answers
Alter schema sql
SQL
0 vote196 views1 answer
Java sql insert return id
SQL
0 vote162 views1 answer
Msg 241, level 16, state 1, line 1 conversion failed when converting date and/or time from character string.
SQL
0 vote195 views2 answers
Tsql row number
SQL
0 vote253 views1 answer
Sql to excel pgadmin
SQL
0 vote190 views1 answer
Oarcale list objects
SQL
4 votes255 views2 answers
Installing sql on ubuntu
SQL