很简单的if else 语句！！！

[zhoumeifang]

我现在想检测一张表，如果表存在，就删除它，应该怎么写呀

[xdhou]

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

[Frewin]

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

[filebat]

--假定表名为表A
if object_id('表A') is not null drop table 表A
go
create table 表A (...)

--另问,这种方法和直接查sysobjects方法,会不会出现查出的效果不一致?

[GRLD8888]

if exists(select name from sysobjects where name='table1')
drop table table1
else
create table table1 (id int,name varchar(8))