Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kashyapsid
Yak Posting Veteran
78 Posts |
 Posted - 2010-04-09 : 03:18:16
|
| Wt is the exact Need of a primary key. At my opinion a primary key is used for Not to produce Duplicate Rows is this right definition?KaShYaP |
|
|
pk_bohra
Master Smack Fu Yak Hacker
1182 Posts |
Posted - 2010-04-09 : 03:27:04
|
| It speedup queries because data is sorted.It helps in uniqely identify a row.You can establish relationship with other tables.You can google for more benefits of primary key.Regards,I am here to learn from Masters and help new bees in learning. |
 |
|
|
rajdaksha
Aged Yak Warrior
595 Posts |
Posted - 2010-04-09 : 03:55:33
|
| HiAlso.. :)1.A primary key field is an index that greatly speeds up queries, searches and sort requests.2.When you add new records, you must enter a value in the primary key field(s). Microsoft SQL SERVER will not allow you to enter Null values, which guarantees that you will have only valid records in your table.3.When you add new records to a table that has a primary key, Microsoft SQL SERVER checks for duplicate data and doesn't let you enter duplicates for the primary key field.By default, SQL SERVER displays your data in the order of the primary key.-------------------------[R][A][J] |
|
|
|
kashyapsid
Yak Posting Veteran
78 Posts |
Posted - 2010-04-24 : 08:32:12
|
| thats fineKaShYaP |
|
|
|
|
|
|
Primary Key