如果存在表则删除表然后创建Mysql

如果存在表则删除表然后创建Mysql

drop table if exists suspects;
create table suspects(
	id int PRIMARY KEY not null AUTO_INCREMENT,
  xm VARCHAR(20),
	xb VARCHAR(20),
	gmsfhm VARCHAR(100),
  csrq DATE,
  whcd VARCHAR(100),
  hyzk VARCHAR(100),
  fwpcs VARCHAR(100),
  sspcs VARCHAR(100),
  djrq VARCHAR(100),
  zjxy VARCHAR(100),
  hjd VARCHAR(100),
  hjd2 VARCHAR(100),
  xzd VARCHAR(100),
  xzd2 VARCHAR(100)
);
           

如果存在这个表，则删除这个表的各种sql写法

  mysql

drop table if exists address_book
           

sql2005:

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[表名]') AND type in (N'U'))
DROP TABLE [dbo].[表名]
           

sql2000:

IF  EXISTS (SELECT * FROM sysobjects WHERE object_id = OBJECT_ID(N'[dbo].[表名]') AND type in (N'U')) DROP TABLE [dbo].[表名]