Uwe Grauer wrote:
> What is a table without a primary key good for?
> Can you come up with a practical use for this?

An intermediary table for getting M:M joins that doesn't have any other 
meaningful information other than the two foreign keys really doesn't 
require a primary key. IOW:


customers
---------
pk
name
...


categories
----------
pk
name
...


cust_cat
--------
cust_fk
cat_fk


I've gotten in the habit of making a cust_cat.pk anyway, even though it 
isn't ever used anywhere. I could also do (cust_fk, cat_fk) as the PK 
but I've just never taken to that approach.


-- 
pkm ~ http://paulmcnett.com


_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev
Searchable Archives: http://leafe.com/archives/search/dabo-dev
This message: http://leafe.com/archives/byMID/dabo-dev/[EMAIL PROTECTED]

Reply via email to