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

How secure is sql server database?

525


What is set nocount on and what is set nocount off?

515


Where is trigger in sql server?

543


Comment,Datatypes are unlimited

1630


Which feature in sql server 2008 has surprised you? You can name just one. : sql server database administration

502






What are data driven subscriptions?

79


What is Sqlpaging in SqlServer 2005 ?

662


How to create a simple user defined function in ms sql server?

546


What is a trigger what are the advantages of trigger?

531


Explain the relational database management system (rdbms)?

526


Determine when to use stored procedure to complete sql server tasks?

540


How does stuff differ from the replace function?

555


Are connections to sql server encrypted?

578


How to start sql server browser service?

561


What part does database design plays a role in performance of an sql server-based application?

524