Synonyms for Tables

  • Comments posted to this topic are about the item Synonyms for Tables

  • why would anyone need to create a synonym over a temp table?

    Interesting question, thanks Steve

    ____________________________________________
    Space, the final frontier? not any more...
    All limits henceforth are self-imposed.
    “libera tute vulgaris ex”

  • Stewart "Arturius" Campbell wrote:

    why would anyone need to create a synonym over a temp table?

    Interesting question, thanks Steve

    That's what I was thinking.  Why would you?

    -------------------------------------------------------------
    we travel not to escape life but for life not to escape us
    Don't fear failure, fear regret.

  • I assume this is because you might be doing some refactoring, and perhaps want to point a routine to the specific place while you're using a temp table in place of some other object. I don't know that I'd like to do this, especially as it hides the use of tempdb spillage a bit from anyone that's tuning,but you can do it.

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

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