What is the difference between constraints and triggers?

Answer Posted / rishi kumar

Constraint is used for column
Trigger is used for table

Is This Answer Correct ?    23 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is index, cluster index and nonclustered index?

687


Explain try...catch with sql server?

761


What is mean by dml?

734


What sql server means?

740


What is difference in performance between insert top (n) into table and using top with insert?

733






What is use of except clause? How it differs from not in clause?

759


If no size is defined while creating the database, what size will the database have?

746


What is the function of sql server agent windows service?

753


How to write character string constants or literals in ms sql server?

762


How to test values returned by a subquery with the in operator?

880


What is the importance of three tier architecture?

820


Why use sub query in sql server and list out types of sub queries?

720


Can sql servers link to other servers like oracle?

604


what's new in sql server 2016?

729


Which autogrowth database setting is good?

790