If so, then adding an artificial key just for the sake of an integer type adds nothing but redundancy. There is often a sensible natural primary key for your data which has a universal meaning and may not be an integer. Now it's time to set the record straight and conclude whether or not string - or alphabetic - data can make a suitable PK. Part 2 explored String and Numeric data types as Primary Keys in an effort to ascertain whether one is preferable to the other. Recall that, in Part 1, we covered Natural and Surrogate Primary Keys and considered why one might choose one over the other. In this third and final installment of this series on choosing a Primary Key for relational databases we'll be examining some of the reasons for employing string data as a Primary Key (PK). Choosing a Primary Key - Part 3 by Robert Gravelle Strings as Primary Keys
0 Comments
Leave a Reply. |