constraints are use to maintain the relation between the two tables. sql co

what is Constraint? How many types of constraints in SQL ?

Question Posted / krishna

38 Answers
90890 Views
HCL, IBM, NIIT, Wipro, I also Faced
E-Mail Answers

Answer Posted / krishna

constraints are use to maintain the relation between the two tables. sql contains the 5 types of constraints
1.primary key
2.foreign key
3.unique key
4.Not null
5.check

Is This Answer Correct ?

2 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is an indexing technique?

985

How to set a database state to offline in ms sql server?

1107

Tell me what is difference between clustered and non clustered index?

982

Do I need a report server to run reports in my application?

170

How can I change procedure name in sql server?

1118

What do you mean by an execution plan?

1190

What is proper subset of candidate key?

1045

How you can change the database name in SQL SERVER?

1252

Explain syntax for disabling triggers?

1097

How do triggers work?

996

What is dbcc?

1181

Explain about temporary stored procedure?

1099

What is simple indexing method?

1084

What is dbcc updateusage?

1258

Is it true, that there is no difference between a rule and a check constraint?

1114