Interested to Buy Any Domain ? << Click Here >> for more details...
What are the differences between Database Trigger and
Integrity constraints ?
- 4 Answers
- 18229 Views
- I also Faced
- E-Mail Answers
Answer Posted / kalyana chakravarthy
Intigrity constraints are Proactive-- Like they take the
cols into consideration before sitting on it like if U levy
a PK on a col having duplicate or null values it will not
obey to sit on that col
Triggers are reactive-- Triggres react only when a DML
occurs. When it comes and sit on a table then its starts
working and never considers what happened before it arrival
Both are used to perform business rules
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba
What are records give examples?
What type of database is sql?
What is java sql connection?
What is a database? Explain
What is sql injection owasp?
How do I save a sql query?
What is mutating table error?
what is a join? : Sql dba
What is the difference between microsoft access and sql server?
How to start the command-line sql*plus?
What is 19 null in sql?
What is sql*loader and what is it used for? : aql loader
What are dml commands?
What is varchar sql?
