adspace


Why do we use triggers?

Answer Posted / Vikas Chaudhary

Triggers are used in SQL to automatically enforce business rules and perform actions before or after an event (INSERT, UPDATE, or DELETE) occurs on a table. They help ensure data integrity and consistency.

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

1156


what is collation? : Sql dba

1242


Is primary key clustered index?

1028


Is primary key always clustered index?

1101


Is inner join faster than left join?

1287


what are all the common sql function? : Sql dba

1141


What is the current version of sql?

1106


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

1124


define sql insert statement ? : Sql dba

1110


what is schema? : Sql dba

1163


If a cursor is open, how can we find in a pl/sql block?

1252


what is bcp? When does it used? : Sql dba

1065


what is sql server agent? : Sql dba

1189


Do we need to rebuild index after truncate?

1154


What is the current version of postgresql?

1188