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

How to optimize stored procedures in sql server?

874


What is the maximum number of instances in 32 bit and 64 bit sql server 2012?

758


Please explain go command in sql server?

794


How to disable a login name in ms sql server?

777


Explain difference between cross join and full outer join?

759


Tell me what is sql profiler?

812


Do you know what is blocking?

741


Why are you getting errors when creating a new odbc dsn?

859


What type of Index will get created after executing the above statement?

873


How to select all columns of all rows from a table with a select statement in ms sql server?

774


What happens if null values are involved in string operations?

749


What is an identity column in insert statements?

764


Why main is user defined function?

773


How to list all triggers in the database with sys.triggers in ms sql server?

778


What are types of scd? : sql server analysis services, ssas

757