Post reply

Defining Column Names

  • March 8, 2006 at 4:34 am

    #167478

     

     In SQL 2000, what are the basic rules to define column names in a table?

  • March 8, 2006 at 5:10 am

    #625358

    Hi - check identifiers - overview in BOL. Basically

    1 to 128 chars. Start with a letter or underscore. I think you can start with # or @ but it gets confusing.

    Some people allow spaces e.g. 'First Name' but you have to code it [First Name]. Some folk replace the space with an underscore, I find this  hard work when reading out to someone. It also uses more characters than is needed. CamelCaping is my choice e.g. 'FirstName'

     

     

     

  • March 9, 2006 at 3:00 am

    #625615

     Thank You Allen.

      Is there any other important points to be considered at the time of giving field names?

     

  • March 9, 2006 at 3:17 am

    #625617

    A good one I picked up was not to use plurals. E.G use Week not Weeks

  • March 9, 2006 at 10:29 am

    #625757

    After the system reequirements ( see BOL) everything else is convention.  Never use single character column names unless you are into pain.  Whatever you come up with keep it consistent.  Either always use plural or never use plural, Always cap the first letter or never cap the first letter.  Consistency is the key to readability. 

    Scott

     

    Kindest Regards,

    Scott Beckstead

    "We cannot defend freedom abroad by abandoning it here at home!"
    Edward R. Murrow

    scottbeckstead.com

  • March 10, 2006 at 11:01 pm

    #626124

    Thank You very much for all u'r replies.

Viewing 6 posts - 1 through 5 (of 5 total)

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