Put the code before your "create table #t..." statement. Easy way to avoid error messages whether #t already exists or not.
2016-04-06
1,771 reads
One line to drop a (temp) table if it exists
-- Drop table #t if it exists (swallow the error if not) begin try drop table #t; end try begin catch end catch;
Related content
2015-04-10
2,060 reads
2014-05-23
2,251 reads
2013-06-24
2,877 reads
2013-05-24
2,351 reads