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

How to check if stored procedure is running in sql server?

1062

Mention the differences between having and where clause.

1058

What is the difference between a check constraint and a rule?

1253

Write a SQL queries on Self Join and Inner Join.

1043

What is data compression?

1011

How you would rewrite the sql query to return the customerid sorted numerically?

1001

How to scale out a federation by Sql statement?

116

What is the maximum size of column in sql server?

893

What is pivot and unpivot?

1013

Do you know what are the restrictions that views have to follow?

1079

when would you go for denormalization? : Sql server database administration

871

Can you use order by when defining a view?

977

What stored procedure would you use to view lock information?

976

What is the difference between count () and rowcount ()?

1028

what is the system function to get current user's user id? : Sql server database administration

1005