Forum Replies Created
Viewing 3 posts - 1 through 3 (of 3 total)
-
RE: Lookup Table Design
Usually when an abritrary ID is used in place of actual codes it is necessary to provide alternative keys to assure uniqueness of the...
-
RE: Worst Practices - Not Using Primary Keys and Clustered Indexes
LookUp Tables are interesting - using your example (StateCode, StateName). The Statecode should have a primary key and the StateName should have not just an index but a unique index....
-
RE: Data Referential Integrity - when do you use it?
One Word - Always
In 20 + years, yes there were databases over 20 years ago that had RI. I have never created a database that did not use RI.
Viewing 3 posts - 1 through 3 (of 3 total)