Constraints are restrict the invalid data before invoke into the database w

What is the Diff b/w Constraints and Trigeer

Question Posted / manoranan sethy

Answer Posted / manoranan sethy

Constraints are restrict the invalid data before invoke into the database whereas trigger restrict the invalid transaction.

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How does sql profiler work?

753

how can you create an empty table from an existing table? : Sql dba

858

How does a covering index work?

693

What is the max nvarchar size?

678

Can we call stored procedure in function?

706

Describe different types of general function used in sql?

727

Explain the savepoint statement.

813

Is ms sql is free?

712

Can we rollback after truncate?

752

What is compiled query?

744

what is a constraint? : Sql dba

882

How to assign sql query results to pl sql variables?

674

define sql update statement ? : Sql dba

807

Does a primary key have to be a number?

689

Can we use join in subquery?

775