请问怎么在ACCESS数据库里执行CREATE语句新建表呀

xtftbwvfp 2005-07-11 09:45:19
如题:
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
...全文
126 回复 打赏 收藏 转发到动态 举报
写回复
用AI写文章
回复
切换为时间正序
请发表友善的回复…
发表回复

28,408

社区成员

发帖
与我相关
我的任务
社区描述
ASP即Active Server Pages,是Microsoft公司开发的服务器端脚本环境。
社区管理员
  • ASP
  • 无·法
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧