What is the difference between constraints and triggers?

Answer Posted / a.ganesh

constraints is predefined onc, but trigger can be defined
by user

Is This Answer Correct ?    4 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain few examples of stored procedure over triggers?

725


what is denormalization? : Sql server database administration

688


What are the dmvs? : sql server database administration

820


Do you know what is sql service broker?

747


Can you explain different types of locks in sql server?

728


what is a self join? Explain it with an example? : Sql server database administration

676


How to create a stored procedure with a statement block in ms sql server?

789


Where does the copy job runs in the log shipping primary or secondary? : sql server database administration

799


Tell me about joins in database system and explain each in detail.

829


What is a subquery in a select query statement in ms sql server?

836


How and why use sql server?

731


What is ems sql management studio? : sql server management studio

792


What is the difference between a primary key and a unique key? Are they the same?

810


What is oltp (online transaction processing)?

760


To automatically record the time on which the data was modified in a table, which data type should you choose for the column?

736