如果存在表则删除表然后创建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].[表名]