Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

RE: Expand / Collapse
Posted Wednesday, April 6, 2005 3:40 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, August 22, 2008 2:29 AM
Points: 1, Visits: 4

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,





Post #172316
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse