What is the difference between constraints and triggers?
Answer Posted / malini paul
1.Constraint is a statement about a database that is always
true.Whereas triggers constrain what a transaction can do.
2.Constrain applies to existing data in the table and any
statement that manipulates the table.Whereas Trigger does
not apply to data loaded before the trigger was created.
| Is This Answer Correct ? | 3 Yes | 3 No |
Post New Answer View All Answers
What is usually the first word in a sql query?
What is indexing in sql server with example?
What is an index. What are the types?
How to drop an existing stored procedure in ms sql server?
Does an index slow down updates on indexed columns?
What is thr feature of change data capture?
Differentiate sql server reporting services vs. Crystal reports?
tell me what is blocking and how would you troubleshoot it? : Sql server database administration
How do you delete a data source?
What does it mean to invest in the index?
How do I find query history in sql server?
What is 4nf in normalization form?
What are the difference between data mart and data warehouse? : sql server analysis services, ssas
How to make a remote connection in a database?
What is the latest version of microsoft sql server?