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

4 votes102 views1 answer
Force drop all tables postgres
SQL
1 vote107 views1 answer
Oracle drop temporary table
SQL
2 votes107 views1 answer
11:04:35 PM [mysql] Error: MySQL shutdown unexpectedly. 11:04:35 PM [mysql] This may be due to a blocked port, missing dependencies,
SQL
0 vote106 views1 answer
Mysql config slave
SQL
0 vote103 views1 answer
MySql get primary keys of table
SQL
4 votes129 views4 answers
Remove duplicate old value in mysql
SQL
0 vote103 views1 answer
Mysql select where field like in list
SQL
2 votes96 views2 answers
Oracle create table if not exists
SQL
7 votes98 views3 answers
Add primary key to database sql
SQL
104 votes276 views2 answers
Like in mysql
SQL