Constraint are the rules enforced on data columns on table

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

Question Posted / srinivas

Answer Posted / srinivas

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 ?

28 Yes

14 No

Please Help Members By Posting Answers For Below Questions

What is failover clustering overview?

1077

What is tabulation?

942

Explain what are various ways to enhance the ssrs report?

1036

What is correlated subquery in sql server?

1058

What are blobs, tables, and Queues? Is SQL is the standard way to query blobs, tables, and queues?

137

What is the importance of three tier architecture?

1079

what is nonclustered index

944

How would you add a section to a table?

1023

What is the process of normalization?

1112

How is sql used in sql server?

997

What is the fillfactor concept in indexes?

972

‘Order by’ is not allowed in a view how can you sort information from a view?

1074

how to do partition in sqlserver

2457

what is a check constraint?

1088

How to generate create view script on an existing view?

978