how to judge if the temptable or normal table that you created exists

just as the following scripts shows:
1.temp table
    if exists (select * from sysobjects where objectproperty(object_id('TempTableName'),'istable') = 1)
2.normal table
   if object_id('tablename') is null
原文地址:https://www.cnblogs.com/Winston/p/1042339.html