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

can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba

630


What is a string data type in sql?

617


Does mysql_real_escape_string prevent sql injection?

624


column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.

6358


Where can I learn sql for free?

603






What is indexing oracle sql?

653


Does google use sql?

598


Mention what pl/sql package consists of?

628


How do I upgrade sql?

647


What are the disadvantages of not performing database normalization?

688


How to get help at the sql prompt?

739


What are sql data types?

646


What is cross join example?

641


Is it possible to link two groups inside a cross products after the cross products group has been created?

685


Explain the advantages and disadvantages of stored procedure?

736