When I started my current (and first) developer job I inherited a database table naming convention which used prefix of 't' on every table eg tOrders, tProducts etc. Is there any point in this? The only use I can see for this is to differentiate tables from views, but is there even any point in this?
I was reminded of this today, when, as part of an interview process, a candidate demonstrated some work which used 'tbl_' at the start of every table name. Not only this, but he prefixed each field name with 'fld_'. I really can't see the point in this, but I'm presuming he picked the habit up somewhere.
On the topic of prefixes, I do find myself using field names like productID, productName etc. Is it more fitting/clear/easy to just use 'id', 'name' as field names, as id and name are attributes of (for example) a product? So a product's name or id can easily be referenced by product.name, product.id, or using a suitable alias. Or would this make queries with multiple joins ultimately more difficult to read?