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

how can you attach more than 20 ldf files in sql server

1575


What have included columns when we talk about sql server indexing?

581


Do you know clustered and non-clustered index?

533


What is not null constraint?

628


How do I setup a sql server database?

552






How do you size a resultset?

504


How do I shrink an ldf file?

572


Write the SQL query to drop, truncate and delete table.

554


Explain difference between cross join and full outer join?

565


 Explain what is sql override for a source taLle in a mapping?

576


What are joins in sql and what are the different types of joins?

554


What is subreport?

100


Explain subquery and state its properties?

553


Write a query for primary key constraint with identity key word?

581


What is Lock table in SQL?

1006