August 23, 2019 at 12:00 am
Comments posted to this topic are about the item Synonyms for Tables
August 23, 2019 at 5:35 am
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”
August 23, 2019 at 1:32 pm
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.
August 23, 2019 at 5:51 pm
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