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

How do I view a stored procedure in sql server?

944

What are the new features of sql server 2008 r2 reporting service?

193

What do you mean by stored techniques? How would we use it?

977

Explain the etl (extraction, transformation, and loading)?

936

What is the difference between ddl and dml?

1002

How to Update from select query in sql server?

993

What are the different types of locks in the database?

872

What is difference between joins and subqueries?

1050

What is the difference between deallocate cursor and close cursor?

1166

What the different components of Replication and what is their use?

1014

When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?

1049

What is user-defined inline table-valued function?

898

What is a partitioned view?

948

Explain sql server authentication modes?

1074

Can we insert data into a view?

1061