Posted by Cecil on 12/28/05 14:50

OK, can you help me to understand why ID and name are poor field
choices. I am asuming it has to do w/ ambiguity. I always qualify
fields w/ their table names for precisely this reason, so I always
concidered something like Category.categoryID to be very redundant.

I prefer Category.ID and Category.name. The only time I would write
CategoryID is if it was a foreign key linking to the "ID" field in the
Category table.

If you believe this to be poor practice, would you please explain why?
Thanks.

[Back to original message]