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 vote193 views1 answer
Sql where time stamp is in between
SQL
13 votes189 views3 answers
Insert mysql ifile nto database
SQL
2 votes205 views1 answer
Express api ith mysql data
SQL
0 vote184 views1 answer
Sql select most frequent value in column
SQL
0 vote182 views1 answer
Postgres sql alter table delete row
SQL
1 vote166 views1 answer
Mysql batch insert
SQL
1 vote181 views1 answer
Job for mariadb.service failed because the control process exited with error code. see "systemctl status mariadb.service" and "journalctl -xe" for details.
SQL
10 votes167 views1 answer
Oracle dependency
SQL
0 vote186 views1 answer
MySQL error code 2068
SQL
0 vote182 views3 answers
How to increase size of column in sql
SQL