What are the differences between Database Trigger and
Integrity constraints ?
- 4 Answers
- 16655 Views
- I also Faced
- E-Mail Answers
Answer Posted / rao
main diff is when we use the trigger voilation rules of
trigger body will not affect existing data.but in case of
constrinat will affect the exsting data also.
| Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
What is multiple columns?
How to write pl sql program in mysql command prompt?
how can we optimize or increase the speed of a mysql select query? : Sql dba
What's the procedure?
Is sql better than excel?
What is an ndf file?
What are the basic techniques of indexing?
how to install mysql? : Sql dba
How do you truncate?
Is it possible to update views?
what happens if you no create privilege in a database? : Sql dba
Can we alter stored procedure?
- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?
How do I debug a stored procedure?
Explain the uses of database trigger.
