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

5 votes370 views1 answer
Sql add column after another
SQL
1 vote354 views1 answer
Sql first
SQL
16 votes409 views1 answer
Mysql mediumint max value
SQL
0 vote341 views2 answers
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created at' in 'field list' (SQL: insert into `categories` (`category_name`, `user_id`, `created at`) values (sea fish, 1, 2021-09-24 04:17:31))
SQL
6 votes351 views2 answers
Sql query to get the number of rows in a table
SQL
0 vote357 views3 answers
Duplicate row mysql
SQL
9 votes373 views3 answers
Mysql run sql file
SQL
32 votes352 views6 answers
Insert into values select
SQL
18 votes350 views3 answers
Mysql query add column with default string value
SQL
10 votes349 views2 answers
Linux command line import mysql database
SQL