use master
go
进入MASTER数据库
if exists (select * from dbo.sysdatabases where name = 'Student')
drop database Student
GO
如果数据库Student存在,删除Student数据库
create database Student
go
use Student
go
建立Student数据库(少建立的语句),进入Student数据库
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[user_Info]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[user_Info]
GO
如果user_Info表存在,删除user_Info表
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[student_Info]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[student_Info]
GO
如果student_Info表存在,删除student_Info表
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[result_Info]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[result_Info]
GO
如果result_Info表存在,删除result_Info表
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[gradecourse_Info]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[gradecourse_Info]
GO
如果gradecourse_Info表存在,删除gradecourse_Info表
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[course_Info]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[course_Info]
GOif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[class_Info]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[class_Info]
GO
建立user_Info表
CREATE TABLE [dbo].[user_Info] (
[user_ID] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[user_PWD] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[user_Des] [char] (10) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO
建立student_Info表
CREATE TABLE [dbo].[student_Info] (
[student_ID] [int] NOT NULL ,
[student_Name] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[student_Sex] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
[born_Date] [datetime] NULL ,
[class_NO] [int] NULL ,
[tele_Number] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[ru_Date] [datetime] NULL ,
[address] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[comment] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
go
进入MASTER数据库
if exists (select * from dbo.sysdatabases where name = 'Student')
drop database Student
GO
如果数据库Student存在,删除Student数据库
create database Student
go
use Student
go
建立Student数据库(少建立的语句),进入Student数据库
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[user_Info]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[user_Info]
GO
如果user_Info表存在,删除user_Info表
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[student_Info]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[student_Info]
GO
如果student_Info表存在,删除student_Info表
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[result_Info]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[result_Info]
GO
如果result_Info表存在,删除result_Info表
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[gradecourse_Info]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[gradecourse_Info]
GO
如果gradecourse_Info表存在,删除gradecourse_Info表
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[course_Info]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[course_Info]
GOif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[class_Info]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[class_Info]
GO
建立user_Info表
CREATE TABLE [dbo].[user_Info] (
[user_ID] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[user_PWD] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[user_Des] [char] (10) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO
建立student_Info表
CREATE TABLE [dbo].[student_Info] (
[student_ID] [int] NOT NULL ,
[student_Name] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[student_Sex] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
[born_Date] [datetime] NULL ,
[class_NO] [int] NULL ,
[tele_Number] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[ru_Date] [datetime] NULL ,
[address] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[comment] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
use master 的意思是 用master 这个数据库
我可以改为其他的吗,我是 指在 工具栏 里选个默认的 自己建的数据库 ,是不是该把这句话 删掉呢》?
if exists (select * from dbo.sysdatabases where name = 'Student')
drop database Student
中用到了dbo.sysdatabases系统表
未能在 sysdatabases 中找到数据库 'Student' 所对应的条目。没有找到具有该名称的条目。请确保正确地输入了名称。
=============================
怎么办 ?
go <<===========这里你没写go吧!
use Student
go
go
use Student
go
建立Student数据库(少建立的语句),进入Student数据库
应该是sql server自己生成的script。若数据库存在则删除之,再建立该数据库,若表存在则删除之,再建立该表