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.art...@gmail.com> To: Martin Gainty <mgai...@hotmail.com> Cc: mysql@lists.mysql.com <mysql@lists.mysql.com> 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 opposite: Customer_tbl Customer_Dead_boo Customer_DOB_date Customer_qs (that means Query Select) Customer_qu (that means Query Update) Customer_qd (that means Query Delete) CustomerOrders_tbl 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. Arthur