#12003/3/6 22:35:41
我得到一个后缀名为sql的文件,用editplus打开一看,仿佛是一段构建sql数据库的代码,比如:
-
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[apply]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[apply]
GO
CREATE TABLE [dbo].[apply] (
[apply_id] [int] IDENTITY (1, 1) NOT NULL ,
[user_id] [int] NULL ,
[apply_type] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sex] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[number_id] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[username] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[oicq] [int] NULL ,
[typerefid] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[http] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[jingyan] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[yewu] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[youshi] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[fukuan] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[yijian] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[remark] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[balance] [int] NULL ,
[dateandtime] [datetime] NULL ,
[orgname] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[zhiming] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[yingye] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[tel] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[fax] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[email] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO
请问能否运行这个文件构成一个sql数据库?