I join you Arthur. That Hungarian notation is despicable (though I love listening to that language, it is different).
I don't find it necessary for a column name to tell me its type.
But I do like the ability to have all database objects (table, column, trigger, index, fk, views, procedures, etc.) sortable and searchable. I use a prefix though. My prefix is a number for one reason: Ease of communication with stuff. A schema is assigned to a range of numbers.
Sounds old fashioned? Cobolish? So?
My 2c. David.
----- Original Message -----
From: Arthur Fuller <fuller.artful@stripped>
To: Martin Gainty <mgainty@stripped>
Cc: mysql@stripped <firstname.lastname@example.org>
Sent: Sun Aug 07 19:03:43 2011
Subject: Re: Hungarian Notation [Was Re: Too many aliases]
I despise this sort of notation, and have instead adopted what have
cheerfully named Hungarian Suffix notation, the reason being Signal-To-Noise
ratio. Instead of prefacing everything with some form of prefix, just do the
Customer_qs (that means Query Select)
Customer_qu (that means Query Update)
Customer_qd (that means Query Delete)
Customer_frm (a form that opens the Customer table; could involve subforms,
but in that case they are named Customer_Orders_fsub,
Customer_Payments_fsub, and so on.
Easy to read, obvious the intent, and easily sortable. Just my opinion.