Naming index on temporary table

Last post 09-09-2008 1:36 AM by FrankKalis. 1 replies.
Page 1 of 1 (2 items)
Active Topics My Discussions Unanswered Sort Posts: Previous Next
  • 09-08-2008 9:05 PM

    Naming index on temporary table

    Temporary table name is prefixed with '#', does it apply in naming its index or it doesn't matter?  Is there any rule or convention for naming the index on a temporary table?

     Thanks in advance.
     

    Filed under: ,
  • 09-09-2008 1:36 AM In reply to

    Re: Naming index on temporary table

    There are no special rules for indices on temporary tables. The standard rules for identifiers in SQL Server apply here.

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Contributing Editor, Writer & Forum Moderator http://www.sql-server-performance.com
    Webmaster: http://www.insidesql.org
    View Frank Kalis's profile on LinkedIn

    XING
Page 1 of 1 (2 items)
Active Topics   My Discussions    Unanswered Posts


© 2000 - 2007 vDerivatives Limited All Rights Reserved.