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 vote301 views4 answers
Mysql on kubernetes
SQL
1 vote308 views1 answer
Mysql decimal allow negative values?
SQL
0 vote380 views1 answer
SCRAM authentication requires libpq version 10 or above (SQL: select * from information_schema.tables where table_schema = public and table_name = migrations and table_type = 'BASE TABLE')
SQL
3 votes284 views1 answer
V$session not found in oracle
SQL
0 vote291 views1 answer
Add colum date in sql
SQL
0 vote304 views1 answer
Renombrar tabla mysql
SQL
0 vote320 views1 answer
Get last three characters in mysql column
SQL
2 votes311 views4 answers
2nd highest salary in mysql
SQL
0 vote309 views1 answer
Sql get date from timestamp
SQL
0 vote297 views1 answer
Fetcht he leftmost word in a comma separated string in sql
SQL