Where Do Temporary Tables Get stored in sql server?
Temporary tables are stored in tempdb Database. There are various ways to check if a temp table exists outlined here: Check If Temporary Table Exists.
TempDb Will In in SystemDatabase.Temp tables are stored here.
Temporary tables gets stored in tempdb database which is present in SystemDatabase or SystemDatabase -> tempdb -> Temporary Tables