sp_help on temp tables

_{Thursday, February 7, 2013 3:29 PM}

Hi, 

How can I run sp_help on temp tables?

sp_help #temp_table

won't work. 

Thanks

_{Thursday, February 7, 2013 3:33 PM ✅Answered}

All temporary tables are stored in the tempdb.  You must specify the database context of the tempd and then run sp_help:

USE tempdb;GOEXEC sp_help '#temp'

Hope this helps

David Dye My Blog

_{Friday, December 13, 2019 12:41 PM ✅Answered | 2 votes}

Hi Smetah,

You can use like below-

EXEC TempDB..SP_HELP #temp_table;

Regards,

Arulmouzhi

_{Thursday, February 7, 2013 3:38 PM}

Thanks David.