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 vote130 views1 answer
Postgresql create user roles
SQL
0 vote149 views1 answer
Sql show founctions
SQL
1 vote126 views2 answers
Mysql type conversion
SQL
7 votes174 views1 answer
Show line number in sql server
SQL
16 votes140 views4 answers
Ascending order mysql
SQL
0 vote148 views1 answer
Ms sql filter all sympbol
SQL
11 votes170 views2 answers
Set default column value sql
SQL
5 votes166 views1 answer
Migrate sql table another database
SQL
0 vote146 views2 answers
Error while setting value 'ONLY_FULL_GROUP_BY,ALLOW_INVALID_DATES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' to 'sql_mode'
SQL
1 vote146 views1 answer
Mysql view curren querys
SQL