SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help
An online community of DBAs, developers and data intelligence builders, with videos, articles, resources and online events for members and non-members.
Find out more >>
(Rick Dobson) Temp tables are temporary in the sense that they exist for as long as the database connection which created and populated them exists. After the connection is closed, the temp table drops from SQL Server.