Local Temporary Tables not dropped with "drop table"-CodePudding

I have some local temporary tables that I can't drop them, would you know if there is any way to drop them?

enter image description here

Example: enter image description here

It's like they don't exist for me

CodePudding user response：

Those are the internal names given to table variables or currently idle cached temporary tables for stored procedures.

You can't drop them with DROP TABLE.

For table variables/temp tables that are cached as part of an execution plan context then evicting the plan from the cache will also drop the table but you shouldn't do this.