Re: Does it make sense to have 2 unique keys in one table?

>if the columns are partially duplicated, like > >unique key1 unique key2 >column1 column3 >column2 column4 >column3 >column4 > >does this make sense? It depends on if key1 and key2 are the same, and if column4 is a candidate key. If the last case applies, *may be* you don't need key2. It's difficult to tell you with this information only. Is not clear how the tables are related. If you specify the case in more detail, may be we could answer it. -- _________________________________________________________________ Martin Salias martin@merino.satlink.net Merino Aller & Asociados Callao 232, 6to.11 Research & Development Manager (1022) Bs.As, Argentina