Triggers
What is the difference between triggers and constraints?
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Abhishek KumarPosted Aug 26, 2014, 6:40 AM
A trigger is sql statement execute either before or after an update, insert, or delete in a database.
Triggers uses magic tables(inserted,deleted).
Triggers gives good performance.
Constraints :
A check is a piece of SQL which makes sure a condition is satisfied before action can be taken on a record.
Constraints are used to maintain the integrity and atomicity of database.
constraints are of these types NOT NULL,PRIMARY KEY,FOREIGN KEY,UNIQUE KEY and CHECK.
Hope this helps.
Abhishek