Re: [SQL] Unique key field or serverl fks ?

2004-01-12 Thread katarn
Hi, I would like to know opinions about which approach is better: Having a table with a field that works as a unique key, or having several fks that work as a combined key ( all the fks fields )? Depends on the particular situation, you'll need to give details of the tables and their place

Re: [SQL] Unique key field or serverl fks ?

2004-01-12 Thread Richard Huxton
On Monday 12 January 2004 05:51, katarn wrote: > Hi, > > I would like to know opinions about which approach is better: > > Having a table with a field that works as a unique key, or having > several fks that work as a combined key ( all the fks fields )? Depends on the particular situation, you'll

[SQL] Unique key field or serverl fks ?

2004-01-11 Thread katarn
Hi, I would like to know opinions about which approach is better: Having a table with a field that works as a unique key, or having several fks that work as a combined key ( all the fks fields )? Thanks in advance, K. ---(end of broadcast)--- TI