What are constraints? Explain different types of
constraints?

Answer Posted / ravi gupta

constraint define rules that must be followed to maintain
consistency and correctness of data.a constraint can either
be created while creating a table or can be added later.
constraint can be divided into the following types:--
(1)primary key constraint.
(2)unique constraint.
(3)foreign key constraint.
(4)check constraint.
(5)default constraint.

Is This Answer Correct ?    4 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?

611


What are the advantages of sql azure?

126


User wants only to display only pdf as export option in report manager. How to achieve this?

187


Explain indexes disadvantages?

633


What happens if the update subquery returns multiple rows in ms sql server?

690






What do you mean by authentication modes in sql server?

697


How do I port a number to sql server?

597


What are the different types of indexes?

685


What is the maximum length of an alert name?

697


Explain Capacity planning to create a database? and how to monitor it?

3851


How to convert numeric expression data types using the cast() function?

638


What is meant by datasource?

592


What is the difference between Normalization and De-normalization?

672


how to do partition in sqlserver

2052


what is blocking? : Sql server database administration

595