Hi There,

I have been working with Databases for about 3 years, I dont claim to know more than you, I would just like to discuss my convetions with you and get your opinion.

Obviously we all have different ways of working with tables but I have identified 3 main types of tables which are: Main Tables(Eg Customer) = m_Customer
      Lookup Tables (Eg Account Type) = l_accType
      Cross Lookup Tables (Eg Account & Payment status) = x_accPayStat

This helps the sorting on your tables as well, as they are sorted by name in SQL server.

For views I use the prefix vw (eg vw_cusAcc) = Customer Accounts
For procedures I use the prefix proc (eg proc_mrgeAcc) = Merge Accounts

I think camel case is the best way of naming columns as well with a self defined prefix eg the m_Customer table will have the prefix cus_firstName,cus_lastName you get the basic idea.

This is my convention hope this comment helps.

Kind Regards,

Danny