The tempdb system database is a global resource that is available to all users connected to the instance of SQL Server and is used to hold the following
Temporary user objects that are explicitly created, such as: global or local temporary tables, temporary stored procedures, table variables, or cursors.