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 vote199 views1 answer
Mysql get first 2 characters of string
SQL
2 votes159 views1 answer
Sql server find table name
SQL
2 votes181 views1 answer
Mysql change data type of column
SQL
-2 votes164 views1 answer
Modify column name in tsql
SQL
3 votes208 views1 answer
Laravel paginate raw sql
SQL
4 votes239 views2 answers
Delete all table oracle
SQL
0 vote198 views1 answer
Creating h2 database in relative directory eclopse
SQL
1 vote188 views1 answer
Key validation sql
SQL
0 vote172 views1 answer
Create sql table from script inline primary key constraint
SQL
1 vote162 views3 answers
Rename table snowflake
SQL