在日常脚本开发中,为了脚本重跑的方便需要自动删除已建临时表以避免建表报错,以下列举3中不同数据库的方法:
(1)Sql Server 2008 :
if exists(select * from datas.dbo.sysobjects where name='tablename')
drop table datas.dbo.tablename;
(2) Mysql:
drop tablename if exists suspects;
(3)oracle
declare num number;
begin
select count(1)
into num
from all_tables
where table_name = 'tablename' and owner='DWD';
if
num=1
then
execute immediate 'drop table tablename';
end if;
end;