Post reply

column name starting with _ (underscore)

  • September 28, 2006 at 3:45 pm

    #103250

    Reality check needed.

    Would you ever start a column name with an underscore?  If you would, why would you do that?

    Thanks for your thoughts on this.

    -A.

  • September 28, 2006 at 4:21 pm

    #663185

    I Wouldn't.  In fact I can't remember the last time I ever created on with an underscore (but I've seen it done often, never in the front however).

  • September 28, 2006 at 5:15 pm

    #663194

    There're a whole bunch of articles out there on naming conventions alone - none that I've seen that justifies starting any name with an underscore...I've also seen spaces used in object names and keep wondering how much of a pain it must be to use these in the front-end application...at least spaces lend to readability but I cannot think of a similar argument for underscores....

    Is the creator of underscores not reachable any more...maybe you could ask him/her ?!?!







    **ASCII stupid question, get a stupid ANSI !!!**

  • September 28, 2006 at 5:34 pm

    #663198

    Been there.  Don't you ever dare putting a space or "¿" in the table name. 

  • September 29, 2006 at 2:53 am

    #663251

    The only excuse I've ever heard for starting a database field with an underscore was that it was then a direct match for a field in the client program (C++ has a lot to answer for!).  Data abstraction obviously means nothing to some people   There's no need for underscores imho.

  • September 29, 2006 at 8:20 am

    #663338

    I use double underscores at the beginning and ending of a column name when I am writing an application that will have user named columns.  Its not a C++ thing, I just want to guarantee that the column name will be unique.

  • September 29, 2006 at 8:28 am

    #663343

    Bill - can you elaborate on that ?! What do you mean by a user named column - as opposed to a system table & columns - a dbo column ?!?!?! Can you provide examples to illustrate ?!







    **ASCII stupid question, get a stupid ANSI !!!**

  • September 29, 2006 at 8:36 am

    #663344

    You have just confirmed my opinions.  You wouldn't believe the reason I was given for wanting to use this convention.  Too moronic to even post.

    Thanks for the feedback and reality check.

  • September 29, 2006 at 8:41 am

    #663346

    That's it, now you'll have to tell us what it is .

  • September 29, 2006 at 8:44 am

    #663349

    Angela - moronic or not it'd be helpful to know what the person was thinking when he/she created those names...it'll also help others with similar reasoning see all the "cons" involved..







    **ASCII stupid question, get a stupid ANSI !!!**

  • September 29, 2006 at 8:47 am

    #663350

    tools that build databases.  what names can you be sure you customers are not going to use?

  • September 29, 2006 at 9:35 am

    #663368

    "Because it makes the column stand out"

    Need I say more?

  • September 29, 2006 at 9:45 am

    #663374

    Unfortunately you have me intrigued enough that I do want you to "say more" - so these must be specific columns that need to "stand out" - where exactly are they standing that they're instantly spotted and distinguished from their non-underscored relatives?!?!

    Don't worry if you don't have the time to post a response - I'll just let my imagination run riot - it's a Friday after all!







    **ASCII stupid question, get a stupid ANSI !!!**

  • September 29, 2006 at 9:49 am

    #663379

    yes please!!!!!

Viewing 14 posts - 1 through 13 (of 13 total)

You must be logged in to reply to this topic. Login to reply