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 the difference between functions and scalar functions?

1200

Difference between connected and disconnected database in .net with sql server?

1092

What is the partitioning method?

1016

Do you know exporting and importing utility?

1037

What is the significance of master, tempdb and model databases?

1071

What is trace flag in sql server?

1016

Name few endpoints exposed by ssrs 2012?

355

How dts is used to extract, transform and consolidate data?

1069

How to connect sql server management studio express to sql server 2005 express?

1032

What is the boxing and unboxing concept in .net?

913

You want to implement the many-to-many relationship while designing tables. How would you do it?

995

What is the purpose of a table?

957

Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?

1061

What is SQL Azure Data sync?

121

How to retrieve error messages using odbc_errormsg()?

1045