What is the difference between constraints and triggers?

Answer Posted / nageswarao

Constraints are predefined business rules in which all the
organisations follow this constraints without any
modification.

trigger is a user defined business rule for which user is
responasible for logic for business rule

Is This Answer Correct ?    9 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is cursor in ms sql server?

656


what is a live lock? : Sql server database administration

567


How connect excel to sql server?

589


What is implicit cursors?

630


How can I tell if sql server is 32 or 64 bit?

583






How to define output parameters in stored procedures?

625


What are the differences between stored procedure and the dynamic sql?

664


what is the information that can be stored inside a bit column? : Sql server database administration

600


List the different types of joins?

652


What is similarity and difference between truncate and delete in sql?

657


Differentiate between mongodb vs. Sql server?

675


Explain trigger classes i.e. Instead of and after trigger?

567


your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files? : Sql server administration

657


Explain Normalization and DE normalization

689


What is explicit cursors?

638