if object_id('tbname','u') is not null
   select 'tbname存在'

------解决方案--------------------

SQL code

if exists(select * from sysobjects where name='table1' and type='u')
   delete from table1
else
   create talbe talbe1
   (
   )