I think I understand where Mike is coming from. When you're maintaining a massive legacy system that has a bad data model, as long as it works at all you sometims have to work around it until you convince the powers that be to remodel it.

>>So true. I've been maintaining systems with tables without primary keys which work fine. In some cases having no primary key isn't that much of a problem.
>>
>>For all new systems I develop I always use a PK, for convinient reason.
>>
>
>Walter,
>
>Show me an example of a table design without a primary key? I have seen some and it is always in a review of a system that isn't working correctly because there is no unique identifier of a record. Are you confusing the primary index with the primary key here?