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 programming language would you use to create embedded functions in ssrs?

184

What are the different SQL Server Versions you have worked on?

992

What is the chart in report?

158

How will you know when statistics on a table are obsolete?

1074

What is t-sql script to take database offline – take database online.

1072

What is BCP? When does it used in sql server 2012?

1051

What is temporal data type?

907

What is normalization? What number of normalization shapes are there?

1098

is there a column to which a default can't be bound? : Sql server database administration

1003

What are the filtered indexes?

1029

What is a select query statement in ms sql server?

1065

What is use of attribute hierarchy ordered ? : sql server analysis services, ssas

1004

What is the main difference between ‘between’ and ‘in’ condition operators?

1177

what is a self join? Explain it with an example? : Sql server database administration

938

How can you find out how many rows returned in a cursor?

1020