Constraint are the rules enforced on data columns on table types of cons

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

Question Posted / kumari

Answer Posted / kumari

Constraint are the rules enforced on data columns on table

types of constraints:

PRIMARYKEY
FOREIGN KEY
NOT NULL
UNIQUE KEY
CHECK
DEFAULT
Check

Is This Answer Correct ?

111 Yes

33 No

Please Help Members By Posting Answers For Below Questions

What is the fillfactor concept in indexes?

944

What do you mean by cardinality?

856

What is dbcc command in sql server?

1025

Does the unique constraint create an index?

997

Recommend an approach to ensuring that all changes in the remote databases synchronize with the SQL Azure database?

128

What is the difference between a fill factor of 100 and 0?

926

How to Insert multiple rows with a single insert statement?

1008

What is dknf in normalization form?

996

What are the types of database recovery models?

1062

Is the order of columns in the set clause important in ms sql server?

933

What are the system database in sql server 2005?

992

What is rtm version in sql server?

989

Please differentiate between a local and a global temporary table?

956

What is the difference between sql server 2000 object owner and sql server 2005 schema? : sql server database administration

949

How can you tell if a database object is invalid?

1025