We assign every table in all databases a unique 3 character prefix. Then
our columns would be prefixed with that.
For your example I might assign the prefix evt so the columns become
evt_Start, evt_End, evt_Info. This helps in that you can then reference
fields and not have to worry about the "uniqueness" of the name.
For example, every table of ours has an identity column. We would call this
field evt_id and in another table maybe evd_id. Then I could say:
SELECT evt_id,
evt_somedata,
evd_id,
evd_otherdata
FROM events
LEFT OUTER JOIN eventdetail
ON evt_id = evd_evt_id
WHERE evt_somefield = 'some data'
Hope this helped.
______________________________________________________
Bill Grover
Supervisor IS Department Phone: 301.424.3300 x396
EU Services, Inc. FAX: 301.424.3300 x1396#
649 North Horners Lane E-Mail: mailto:[EMAIL PROTECTED]
Rockville, MD 20850-1299 WWW: www.euservices.com
______________________________________________________
> -----Original Message-----
> From: Mark Smeets [mailto:[EMAIL PROTECTED]]
> Sent: Friday, December 21, 2001 1:53 PM
> To: CF-Talk
> Subject: general question about naming conventions
>
>
> So, a general question,
>
> When dealing with databases, how do you name your columns?
>
> Example: Table Name: Events
> Column(s): Start, End, Info
>
> Would you name it like this
> (a)Start, End, Info
> (b)eStart, eEnd, eInfo
> (c)cStart, cEnd, cInfo
> (d)or something completely different
>
> (the c stands for column)
>
> This doesn't have to be answered over the list, private email
> is good too.
> Just curious as to what others do.
>
> --------------------------------------
> Mark Smeets / stranger0 / ICQ: 1062196
> [EMAIL PROTECTED]
> http://www.prowerks.com/stranger
>
> Question: "What is the first thing you notice about a person?"
>
> "Whether or not they're on fire." - Weird Al Yankovic
>
>
> FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
> Archives: http://www.mail-archive.com/[email protected]/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
______________________________________________________________________
Get Your Own Dedicated Windows 2000 Server
PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation � $99/Month � Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
