What is the difference between constraints and triggers?

Answer Posted / vampire007

I dont' think Triggers are performanc wise more superior to
constraints. Constraints are isolated to table level
whereas triggers are flexible to do the validation on any
number of tables.

Is This Answer Correct ?    6 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is sql server english query?

547


Hi all, can any one please tell me the difference between sql server 2008 and orace 9i

1530


write an SQL query to list the employees who joined in the month of January?

1155


what types of replication are supported in sql server? : Sql server database administration

466


What is the difference between for trigger and after trigger?

547






Can one drop a column from a table?

552


How many types of keys are there?

530


What is nolock?

560


Which sql server table is used to hold the stored procedure script?

476


What is the partitioning method?

533


what changed between the previous version of sql server and the current version? : Sql server database administration

520


What is sql server transaction log file?

524


Can you force a query to use a specific index?

533


Explain tables in SQL Azure?

96


Should you normalize audio?

531