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 |
|
nishithrn
Yak Posting Veteran
58 Posts |
 Posted - 2003-04-20 : 05:00:01
|
| Hi,What is a surrogate key, and how to implement it..??Tx.. |
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2003-04-20 : 12:37:44
|
| http://www.dbpd.com/vault/9805xtra.htmIf you search the site there are large discussions about this topic.It's a topic of heavy debate. |
 |
|
|
harshal_in
Aged Yak Warrior
633 Posts |
Posted - 2003-04-21 : 02:49:35
|
| When business-related columns are used as primary keys they are often called intelligent or natural keys. For example, if the user gives each customer a unique customer number that value might naturally serve as the primary key for the customer table. A child table called order might have an intelligent primary key consisting of two columns: customer_number to act as a foreign key pointer to the customer table plus order_date_time to identify different orders for one customer. An alternative is to use system-generated artificial primary key values. These are often called surrogate keys because they are replacements for the intelligent keys, or blind keys because the user doesn't see them. Edited by - harshal_in on 04/21/2003 02:53:21 |
|
|
|
|
|
|
Surrogate Key !!!