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 RMS migrations?

1711


Explain features and concepts of analysis services?

504


What the different types of Replication and why are they used?

546


What are the common performance issues in sql server?

505


What are the advantages of partitioning?

646






How to create a ddl trigger using "create trigger" statements?

616


What is the simplest way to create a new database in ms sql server?

542


How to perform key word search in tables?

536


What are the benefits and tasks of object explorer? : sql server management studio

611


What is bit data type? What's the information that can be stored inside a bit column?

526


How many types of schemas are there?

531


Explain about system database?

580


Do you know concepts and capabilities of sql server?

584


What is a group function explain with an example?

523


Why do you need a sql server?

510