CREATE TABLE [dbo].[aaa](
[aaa] [varchar](255) NULL
)
if exists(select * from information_schema.tables where table_name='aaa')
BEGIN
DROP TABLE aaa
select N'有,所以删除了'
END
else
BEGIN
select N'没有'
END
CREATE TABLE [dbo].[aaa](
[aaa] [varchar](255) NULL
)
if exists(select * from information_schema.tables where table_name='aaa')
BEGIN
DROP TABLE aaa
select N'有,所以删除了'
END
else
BEGIN
select N'没有'
END