请问怎么在ACCESS数据库里执行CREATE语句新建表呀
如题:
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Dict_Provinces]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Dict_Provinces]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Keyword]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Keyword]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[czrecord]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[czrecord]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tbCorporation_cnmj]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[tbCorporation_cnmj]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tbExhiJoinView_cnmj]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[tbExhiJoinView_cnmj]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tbHttplist]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[tbHttplist]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tbInfoSellBuy_cnmj]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[tbInfoSellBuy_cnmj]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tbInfoSellBuy_cnmj8]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[tbInfoSellBuy_cnmj8]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tbInfoType]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[tbInfoType]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tbMember_cnmj]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[tbMember_cnmj]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tbNews_cnmj]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[tbNews_cnmj]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tbZhengshu]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[tbZhengshu]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tbZixun]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[tbZixun]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tbadmin_Log]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[tbadmin_Log]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tbadmin_User]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[tbadmin_User]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tbadmin_part]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[tbadmin_part]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tbadmin_power]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[tbadmin_power]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tbadmin_powername]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[tbadmin_powername]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tbchenggong]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[tbchenggong]
GO