1) PRIMARY KEY IS USED AS UNIQUE KEY, FOR AVOID DUPLICATION. 2) FOR VALIDA

What is the use of placing primary key and foreign key
constrains on columns.

Question Posted / deepak

Answer Posted / deepak

1) PRIMARY KEY IS USED AS UNIQUE KEY, FOR AVOID DUPLICATION.
2) FOR VALIDATING DATA FROM PRIMARY KEY TABLE FOREIGN KEY USE.

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is difference between count (*) and count column?

903

Tell me what is normalization? Explain different forms of normalization?

1030

What is log shipping? Can we do logshipping with SQL Server 7.0 ?

993

What happens when the SQL Azure database reaches Max Size?

111

What are the different types of backups avaialabe in sql server 2005?

1021

What does it mean to manipulate data?

992

can we have a nested transaction? : Sql server database administration

1095

What are the differences between INNER JOIN, LEFT JOIN and RIGHT JOIN in SQL Server?

1135

What is buffer cash and log cache in sql server?

1123

Define Business Edition in SQL Azure?

100

What are the differences between triggers and stored procedures?

1070

What is difference between equi join and natural join?

1041

Can we add an identity column to decimal datatype?

1002

What is the difference between clustered and a non-clustered index?

1028

What is a trace frag? Where do we use it?

1100