do we need to drop the #temp table after select into

Question

I know we will have to drop the table manually after using create table, but how about select into #temp ? will it be cleaned up at the end of the the stored proc? thanks

Answer 1

Better late than never, I suppose. In case other people have trouble finding the documentation:

A local temporary table created in a stored procedure is dropped automatically when the stored procedure is finished.