Constraints are rool of data integrity. Types of Constraints are: 1)Not

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

Question Posted / vijaya

Answer Posted / vijaya

Constraints are rool of data integrity.

Types of Constraints are:
1)Not Null
2)Unique
3)Primary Key
4)Check
5)References.

Is This Answer Correct ?

39 Yes

11 No

Please Help Members By Posting Answers For Below Questions

What does asynchronous call backs means?

1146

How many types of objects are there?

997

What are constraints in microsoft sql server?

1117

Explain the Ways to improve the performance of a sql azure database?

Explain different types of collation sensitivity?

973

What are the difference between data mart and data warehouse? : sql server analysis services, ssas

954

What is bulkcopy in sql?

937

How to generate create procedure script on an existing stored procedure?

1004

Disadvantages of the indexes?

1112

What is normalization? Explain its different types?

1079

How to view existing indexes on an given table using sys.indexes?

1085

What is fill factor and pad index?

1005

What is the use of commit?

994

Explain what is “asynchronous” communication in sql server service broker?

908

Define constraints and give an example of their use?

1037