>Actually I probably dislike it for the exact reason that you like it. I only have to alias fields in selects when I repeat field names. Which I seldom do.

OIC. The thing is, (practically) every table has a primary key, so if you don't prefix that, at least, you've got to alias.

>I also like to be able to recall the field names w/o having to look them up.

Actually, I've found the system I use helps with that. For example, with a Membership Types table, I don't have to remember whether it's membertype_pk or type_pk, because I use the three-letter abbreviation everywhere.

>And I hate underscores.

I hate 'em, too. In fact, this is about the only place I use underscores; the other is in #defines. Both for the same reason: all upper or all lower case is hard for me to read without word separators.

>All personal reasons. Nothing that should keep someone else from using your standards.

I should've interpreted all that from "Yuck!" :)