What are constraints? Explain different types of
constraints?

Answer Posted / k.swathi

constraint is a mechanism which is used to stop the data entered by the end user by implementing bussiness rules.

contraint are 6 types
1)unique
2)primary key
3)check
4)null
5)not null
6)foreign key(refferential key)

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain what is the function of sql server agent windows service?

550


List the different index configurations possible for a table?

517


What do you mean by an execution plan? Why is it used? How would you view it?

534


Indexes are updated automatically is the full-text index also updated automatically?

629


What are the types of indexing?

602






What options are there to delete rows on the publisher and not on the subscriber? : sql server replication

683


How can I know what locks are running on which resource?

511


What is normalization of database? What are its benefits?

521


How do I create an extended event in sql server?

497


What is report snapshot in ssrs?

166


What is the difference between sdf and mdf?

681


how to trace the traffic hitting a sql server? : Sql server database administration

1144


Define model database?

577


What is normalization process?

604


IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do

1332