if exists (select * from sysobjects where type = 'U' and name = 'table_name')
begin
    drop table table_name
end