mysql:
drop table if exists address_book
sql2005:
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[表名]'DROP TABLE [dbo].[表名] )
sql2000:
IF EXISTS (SELECT * FROM sysobjects WHERE object_id = OBJECT_ID(N'[dbo].[表名]')
orcale:的不知道怎么实现这种操作 ,哪位朋友可以教教我