----- Original Message ----- From: "CT, Loo" <[EMAIL PROTECTED]> To: "SQL" <[EMAIL PROTECTED]> Sent: Thursday, January 03, 2002 9:18 PM Subject: Questions
> Dear SQL gurus, > > I have some questions on database design and hope all experts out there > can give me some ideas/advice. > Please advise/comment on the followings:- > > 1. Should one use the identity field as primary key in designing a > database? No. You should always use a manual numbering scheme, basically because, if ever you have to move this DB to another DB, even of the same type, and it is a truely relational DB, and you have ever deleted records (which I hear happens on occassion), you will have a lot of work ahead of you ensuring that all of the related tables are numbered correctly. > If yes, isn't it has a limitation when the number reaches its > limits? > 2. What would happens to the database when the identity field's value > reaches its limits? Another reason to use a manual numbering scheme. > 3. Any advice on selecting a primary key for a table where none of the > columns has unique value? Create a new table, and then assign a unique value to it. You can do this in CF. Just loop through the table and add a new number each time. > > > > Thanks in advance. > > Kind regards, > CTLoo > > > ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
