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
How to get a list of columns in a view using the "sp_columns" stored procedure?
What are the differences in Clustering in SQL Server 2005 and 2008 or 2008 R2?
Types of Authentications in Sql Server? How user gets authenticated through windows authentication?
What are system databases into sql server (2005/2008) : sql server database administration
Why use view instead of a table?
Which is faster statement or preparedstatement?
What is the use of partition by in sql server?
What is the difference between a check constraint and a rule?
How you can change the database name in SQL SERVER?
What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?
Can you explain different types of locks in sql server?
Explain stored procedure?
What is the difference between TRUNCATE and DROP?
Differentiate sql server reporting services vs. Crystal reports?
What is candidate key with example?