I have some local temporary tables that I can’t drop them, would you know if there is any way to drop them?
Example:
It’s like they don’t exist for me
>Solution :
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.