SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


RE:


Author
Message
Gerhard Senekal
Gerhard Senekal
Forum Newbie
Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: General Forum Members
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,

Danny



Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search