adspace


What are triggers and its uses?

Answer Posted / Amit Kumar Attari

Triggers are SQL routines that automatically execute in response to specific events on a table. These events include INSERT, UPDATE, or DELETE operations. Triggers are useful for maintaining data integrity, enforcing business rules, and auditing changes.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how many tables will create when we create table, what are they? : Sql dba

1144


Can we rollback truncate?

1074


define sql insert statement ? : Sql dba

1098


What is the current version of sql?

1092


Is primary key always clustered index?

1094


how to escape special characters in sql statements? : Sql dba

1113


Does group by remove duplicates?

1112


Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

2090


what is collation? : Sql dba

1229


how to use regular expression in pattern match conditions? : Sql dba

1111


what is dbms? : Sql dba

1061


What is the current version of postgresql?

1177


Do we need to rebuild index after truncate?

1137


Is inner join faster than left join?

1274


Can delete statement be rollbacked?

1053