RE: [SQL] Database Design Question

2001-07-27 Thread Jimmie Fulton
PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: RE: [SQL] Database Design Question OK... Fair Enough... Good Points indeed y'all. Well... What about the problem of users trying to Query the Database?? You know... like when using Crystal Reports or something?. SELECT * from Histor

RE: [SQL] Database Design Question

2001-07-27 Thread Jimmie Fulton
I'm by no means a crack database designer, but I do have my ideas on this subject. I prefer that every table has a unique integer (auto-incrementing) primary key. Why? Consistency. With the alternative, some tables may not have a clear-cut candidate for a unique id. In your example, you had "