what is the difference between trigger and constraint?

Answer Posted / kumar jabu

Constraints implements specific conduct or rules on table column like it determines whether field data should be unique,not null ..
But triiger implements rules on systems or application event.
whenever dml occurs that implemented rules been fired.

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is a database lock ? : Sql dba

585


What is program debugging?

552


Why we use triggers in mysql?

555


what are all different types of collation sensitivity? : Sql dba

518


What is pessimistic concurrency control? : Transact sql

582






Can dml statements be used in pl/sql?

568


What is cursor and why it is required?

547


What is a clob in sql?

558


What is a trigger word?

508


What is a data definition language?

546


What is package in pl sql?

572


discuss about myisam index statistics collection. : Sql dba

519


What is the difference between function, procedure and package in pl/sql?

553


Explain unique key in sql.

554


What is the difference between count 1 and count (*) in a sql query?

491