469,148 Members | 1,548 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,148 developers. It's quick & easy.

temp table name

I created a temp table #t
But in tempdb..sysobjects the name is stored as

#t________________________________________________ __________________________________________________ ________________000000000018

Any reason for extra length?

Madhivanan

Jul 23 '05 #1
1 1071
See the "Temporary Tables" section of CREATE TABLE in Books Online,
where this behaviour is explained.

Simon

Jul 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Per | last post: by
5 posts views Thread by Billy Cormic | last post: by
reply views Thread by joe pribele | last post: by
1 post views Thread by Robert McEuen | last post: by
2 posts views Thread by kizmar | last post: by
reply views Thread by zhoujie | last post: by
1 post views Thread by Mortomer39 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.