Microsoft SQL Server forum - temp table name

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

temp table name

Madhivanan

2005-07-19, 9:23 am

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

#t__________________
____________________
____________________
____________________
____________________
________________0000
00000018

Any reason for extra length?

Madhivanan

Simon Hayes

2005-07-19, 9:23 am

See the "Temporary Tables" section of CREATE TABLE in Books Online,
where this behaviour is explained.

Simon

Sponsored Links