what is the difference between trigger and constraint?

Answer Posted / naga sindhuri

Triggers not apply for existing rows but constraints can
apply for existing rows.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the events on which a database trigger can be based?

584


What is the difference among union, minus and intersect?

538


Can we use update in sql function?

571


Which tcp/ip port does sql server run on? How can it be changed? : Sql dba

486


What is sql mysql pl sql oracle?

561






What is schema in sql?

507


Which is faster count (*) or count 1?

532


Explain locks? : Transact sql

560


Can we rollback truncate?

532


Why do we use set serveroutput on?

507


What is a sql profiler?

585


what are the differences between char and nchar? : Sql dba

589


What is procedure and function?

509


Can you call pl/sql package functions from within a fast formula?

560


Why having clause is used in sql?

530