Naming Conventions for Field Names

Page 1 of 1

3 Replies - 1761 Views - Last Post: 04 July 2006 - 04:10 AM Rate Topic: -----

#1 absta  Icon User is offline

  • D.I.C Head

Reputation: 0
  • View blog
  • Posts: 58
  • Joined: 13-April 06

Naming Conventions for Field Names

Posted 26 April 2006 - 01:43 PM

Guys
Apologies but I couldn't find any info on the forum re. this I might be being really blind, can someone point me in the right direction of a good source re. this

Cheers

This post has been edited by absta: 26 April 2006 - 01:44 PM

Is This A Good Question/Topic? 0
  • +

Replies To: Naming Conventions for Field Names

#2 skyhawk133  Icon User is offline

  • Head DIC Head
  • member icon

Reputation: 1819
  • View blog
  • Posts: 20,238
  • Joined: 17-March 01

Re: Naming Conventions for Field Names

Posted 26 April 2006 - 01:47 PM

I'm curious as well if there is a widely accepted convention for naming fields. I often times go with an abbreviated table name, then the name of the field. For instance:

Table: Categories
Fields: cat_id, cat_name, cat_parent, etc....
Was This Post Helpful? 0
  • +
  • -

#3 absta  Icon User is offline

  • D.I.C Head

Reputation: 0
  • View blog
  • Posts: 58
  • Joined: 13-April 06

Re: Naming Conventions for Field Names

Posted 26 April 2006 - 01:53 PM

more specifically say for instance you had a tblCustomers

you would have DataType Autonumber (Primary Key)
field name would be lngCustID

DataType Text for field name strUsername

DataType Number for field name intPhone

I guess this is acceptable ?
Was This Post Helpful? 0
  • +
  • -

#4 ross_petersen  Icon User is offline

  • D.I.C Head

Reputation: 1
  • View blog
  • Posts: 65
  • Joined: 06-August 05

Re: Naming Conventions for Field Names

Posted 04 July 2006 - 04:10 AM

Absta, there is a company called Superior Software for windows in Australia (Adam Cogan is the CEO/Owner - he is a MVP and is very knowledgeable) that has a whole heap of rules that they use internally.

their web site is:
www.ssw.com.au

Regards

Ross
Was This Post Helpful? 0
  • +
  • -
Page 1 of 1