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