No announcements
Found 878791 threads
-
0 VotesConfusion on Natural Key Primary, vs Surrogate Key Primary
That's actually why I never put a surrogate key on the table, because I never join to any other tables, and every query uses these three natural ...Answered | 9 Replies | 2372 Views | Created by Bloodofgods - Thursday, September 10, 2015 4:26 AM | Last reply by Soumen Barua - Friday, September 18, 2015 3:07 PM
-
0 Votes
Surrogate Key vs Primary Key
Surrogate keys have no business relevance.Answered | 12 Replies | 7382 Views | Created by Naresh_a - Saturday, December 17, 2011 7:25 PM | Last reply by Naomi N - Tuesday, October 21, 2014 3:52 PM -
3 Votes
Surrogate primary key
Hello Louis, Well, I was wondering if there is any new(hopefully, better) way in handling surrogate primary keys.Answered | 14 Replies | 4092 Views | Created by Stan210 - Wednesday, March 6, 2013 5:30 PM | Last reply by Kutub1 - Wednesday, March 13, 2013 2:15 PM -
3 Votes
Primary Key Design Practices
What is the rationale behind (almost) never making a Natural Key the Primary Key?Answered | 18 Replies | 7884 Views | Created by Mercury529 - Friday, November 23, 2012 7:22 PM | Last reply by Naomi N - Monday, November 26, 2012 12:28 AM -
3 Votes
natural key vs surrogate key Table design question
I am looking in to best practice of CI which may or may not be Primary key.Answered | 7 Replies | 927 Views | Created by hphil - Wednesday, November 16, 2016 4:12 PM | Last reply by Uri Dimant - Thursday, November 17, 2016 6:55 AM -
3 Votes
Composite Primary key and Foreign key
This is behavior very difficult to achieve with a surrogate, but trivial with a natural key.Answered | 18 Replies | 61045 Views | Created by mahima - Friday, February 8, 2008 3:51 PM | Last reply by Kalman Toth - Sunday, April 10, 2011 8:52 PM -
1 Votes
Weak entity primary key question
As you are interrogating the model, you have to realize to replace the surrogate keys in the model with the natural keys to get the meaning.Answered | 5 Replies | 11786 Views | Created by sonofjack3 - Saturday, March 9, 2013 8:33 PM | Last reply by Louis Davidson - Tuesday, March 19, 2013 2:51 AM -
2 Votes
Foreign key references a two column primary key
Alejandro re-defined the schema to use one column PK/FK (identity surrogate key).Answered | 13 Replies | 21833 Views | Created by pyram07 - Thursday, June 14, 2012 1:17 PM | Last reply by pyram07 - Thursday, June 14, 2012 6:18 PM -
0 Votes
Identify Column as Primary Key with Foreign Keys Referencing it
I guess you would have to ensure that when a record is added to the Primary, it is also added to the Foreign Key table?Answered | 3 Replies | 5138 Views | Created by Patrick_Cox - Monday, December 9, 2019 12:28 PM | Last reply by Guoxiong Yuan - Monday, December 9, 2019 2:53 PM -
0 Votes
Primary key error
In Table A, i have two fields together as Primary Key.Answered | 8 Replies | 4716 Views | Created by NSG12 - Tuesday, March 30, 2010 3:54 PM | Last reply by Kalman Toth - Sunday, April 4, 2010 12:30 PM -
2 Votes
Using symbols in primary key
We think you need to improve the concept of Primary key What is a key, and why is one of them a primary key?Answered | 2 Replies | 1862 Views | Created by ogzgl - Saturday, July 25, 2015 8:35 AM | Last reply by Ahsan Kabir - Monday, August 3, 2015 4:02 AM -
0 Votes
Datetime Field in Composite Primary Key
However, this advantage is negated a little by requiring structures to manage both the surrogate and the natural key.Answered | 8 Replies | 22080 Views | Created by Bruce Tuttle - Tuesday, December 22, 2009 11:32 PM | Last reply by Jim McLeod - Monday, January 4, 2010 10:36 PM -
9 Votes
why integers are used in primary key?
VIN vs.Answered | 30 Replies | 9411 Views | Created by anjigvr - Thursday, July 30, 2009 5:09 AM | Last reply by Phil Brammer - Saturday, September 12, 2009 12:13 AM -
0 Votes
GUID vs Unique Int for Primary Keys
Surrogate vs.Answered | 2 Replies | 13287 Views | Created by abenitez77 - Monday, March 7, 2011 5:32 PM | Last reply by Naomi N - Monday, March 7, 2011 8:57 PM -
1 Votes
Two Primary key for table???
tHE BOLD line shows that it has two primary key The bold line shows that you have a primary key composed by two columns.Answered | 2 Replies | 4672 Views | Created by Incredible15 - Sunday, September 12, 2010 4:44 PM | Last reply by Hunchback - Sunday, September 12, 2010 5:06 PM -
0 Votes
Is Having Primary key on a table essential?
It is better to have a surrogate key as log date time cannot be unique.Answered | 4 Replies | 4145 Views | Created by Mourmansk - Friday, May 3, 2013 1:38 AM | Last reply by Louis Davidson - Monday, May 6, 2013 9:00 PM -
0 Votes
UNIQUE NONCLUSTERED INDEX or COMPOSITE PRIMARY KEY
A much better idea is INT IDENTITY SURROGATE PRIMARY KEY and UNIQUE KEY constraint on RiskID, ReviewPeriod & Review Year.Answered | 8 Replies | 8661 Views | Created by PadmaSatya - Saturday, October 20, 2012 1:42 PM | Last reply by Erland Sommarskog - Saturday, October 20, 2012 8:06 PM -
3 Votes
PRIMARY KEY
It needs a real world NATURAL KEY such as SSNo or email.Answered | 6 Replies | 1606 Views | Created by I4QR1A - Thursday, November 27, 2014 8:12 PM | Last reply by DileepReddyAchhala - Friday, November 28, 2014 11:21 AM -
1 Votes
Performance of Surrogate Key vs Composite Keys
This question was a subject for this T-SQL ...Answered | 5 Replies | 9185 Views | Created by Ryan0827 - Friday, June 22, 2012 8:56 PM | Last reply by --CELKO-- - Saturday, June 23, 2012 2:47 PM -
0 Votes
Is it necessary to have a primary key in each table
My question is that is it necessary to make Primary key in every table.?Answered | 2 Replies | 9722 Views | Created by SQL_BOSS - Sunday, July 22, 2012 1:03 PM | Last reply by Dan Guzman - Sunday, July 22, 2012 2:04 PM - Items 1 to 20 of 878791 Next ›
No announcements
