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

3 votes357 views2 answers
Sql get month name
SQL
0 vote370 views1 answer
Sqlcmd no headers
SQL
0 vote341 views3 answers
Find below average salary in sql
SQL
4 votes329 views1 answer
Oracle show error line number
SQL
0 vote368 views1 answer
Postgresql delete type
SQL
0 vote361 views1 answer
Postgres row expiration
SQL
0 vote334 views1 answer
Sql query with date
SQL
13 votes357 views2 answers
Get tables in database sql
SQL
0 vote356 views1 answer
In mysql workbench contnent not feching
SQL
0 vote352 views1 answer
FIND AVERAGE SALARY EARNER IN SQL
SQL