求写SQL

[pawly]

如果存在table1则删除table1

[pawly]

有没有简单判断方法

[tingquan]

不会吧,已经够简单的了,要不就采用sun_qiqi的建議,直接drop

[zhuzhichao]

if object_id('table1') is not null and OBJECTPROPERTY(object_id('table1'),'IsTable') = 1
drop table table1;

[zhuzhichao]

Oracle:

declare i int;
begin
select 1 into i from user_tables where table_name = 'TABLE1';
if i = 1 then
execute immediate 'drop table '||'table1';
end if;
end;

[leaf_cq]

sql2000
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[table1]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[table1]
GO

[sun_qiqi]

上边是sqlserver的，不用管存在不存在，反正是删除，直接用drop table1;