Post reply

Prefixing table names with "tab"

  • July 15, 2010 at 5:32 am

    #142041

    It has been suggested to me that table names should be prefixed with tab as it makes it easier to spot the table in some TSQL.

    I find this convention hard to support. Do you find any merit in such a convention?

  • July 15, 2010 at 5:41 am

    #1193384

    Personally I detest all forms of prefixing. It makes things harder to read, not easier, and in most cases the object type is obvious from how it is used. The only real case when it's not is tables/views, since both can be selected from and appear interchangeable (which is good in general).

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • July 15, 2010 at 6:30 am

    #1193426

    Continues at http://www.sqlservercentral.com/Forums/Topic953050-149-1.aspx. No further replies to this thread please.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 3 posts - 1 through 2 (of 2 total)

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