Constraints are the way by Databse managing the data inegrity. Types of

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

Question Posted / lekhraj

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

Answer Posted / lekhraj

Constraints are the way by Databse managing the data inegrity.

Types of constraint are:-
1)NOT Null
2)Default
3)Check
4)Rule
5)Primary
6)Unique
7)Foreign

Is This Answer Correct ?

46 Yes

65 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is raid? : SQL Server Architecture

1230

What is a partitioned view?

1052

What is the difference between implicit and explicit transaction?

1052

What are the new data types are introduced in sql 2000?

949

what's new in sql server 2016?

1003

What is named calculation? : sql server analysis services, ssas

1025

What is the default fill factor value?

1128

Does a specific recovery model need to be used for a replicated database? : sql server replication

1013

Relational calculus is what type of language?

1093

Tell me what do you mean by an execution plan? Why is it used? How would you view it?

947

How to create a simple stored procedure in ms sql server?

1089

Explain foreign key in sql server?

1073

How do I find the default sql server instance?

990

Mention the differences between sql server and mysql.

1086

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

995