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
Concatenate columns in table
SQL
0 vote133 views1 answer
Oracle enable chain
SQL
0 vote131 views1 answer
Groupby sort sql hive
SQL
2 votes147 views1 answer
Sql percentage with % rounded down
SQL
0 vote129 views1 answer
Date datatype in livesql
SQL
1 vote123 views1 answer
Sql auto date
SQL
0 vote154 views1 answer
Sql server pivot rows to columns
SQL
38 votes198 views4 answers
Count sql
SQL
0 vote142 views1 answer
Create database like
SQL
0 vote144 views1 answer
How to add mysql to path on termin after installation
SQL