Constraint are the rules enforced on data columns on table. Five type of

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

Question Posted / mudit

Answer Posted / mudit

Constraint are the rules enforced on data columns on table.

Five type of constraints
Primary key
Unique Key
Foreign Key
Not Null
Check

Is This Answer Correct ?

338 Yes

56 No

Please Help Members By Posting Answers For Below Questions

What is Sqlpaging in SqlServer 2005 ?

843

Explain tables in SQL Azure?

114

What is data set in report?

112

Why we use the openxml clause?

719

Explain error and transaction handling in sql server?

679

How to verify the port number of the sql server?

713

How to create and drop temp table in sql server?

769

What are the filtered indexes?

780

What have included columns when we talk about sql server indexing?

766

What is a db view?

688

How to configure and test odbc dsn settings?

799

Explain view in sql server?

818

Tell me what is fill factor?

714

What is the correct order of the logical query processing phases?

688

What happens if null values are involved in string operations?

716