What are the operations performed by SQL when we execute 'Delete From Table_name' command;
asked
what are the operations by SQL after Delete command;
1 It deletes all the data from the table 2 It writes to the log file what are deleted 3 May throw an error if linked to another table by foreignkey constraint
- 1a) Deletes any associated records with Cascade Delete
- 1b) Fires any associated triggers
