Home Forums Article Discussions Article Discussions by Author Discuss content posted by Sylvia Moestl Vasilik Enhancing the readability of your code: Table aliasing in sql RE: Enhancing the readability of your code: Table aliasing in sql

  • May 7, 2009 at 4:53 am

    #990220

    Jan Van der Eecken (5/7/2009)

    Always upper-case by the way, since I make table/view names upper-case as well. Oh, by the way, I hate the imposing behaviour that SQL2K8 (Un-)Intellisense cases my table names the way they are in the database. Does anyone else have the same gripe?

    There is so much wrong with this 🙂

    Table object is named in one manner e.g. MyTable

    You refer to it as MYTABLE in your queries... removing any consitancies

    SQL Server 2008 Intellisense will be using the same case as the table name in the database as a case sensitive server will not equate [MYTABLE] to [MyTable] which will mean your query will fail

    I really can't see any benefit in not using the same case as the object naturally has, unless the object has been really badly named (CUSTOMERRELATIONSHIPMANAGEMENTTABLEHEIRACHY) and its a case insensitive server