发布时间 : 星期四 文章数据库实验报告-概念模型的建立更新完毕开始阅读
drop table shehuiguanxi go
if exists (select 1
from sysobjects where id = object_id('stu') and type = 'U') drop table stu go
if exists (select 1
from sysobjects
where id = object_id('stufencon') and type = 'U') drop table stufencon go
if exists (select 1
from sysobjects
where id = object_id('stuhj') and type = 'U') drop table stuhj go
数据库原理实验报告
- 8 -
数据库原理实验报告
if exists (select 1
from sysobjects
where id = object_id('stutext') and type = 'U') drop table stutext go
if exists (select 1
from sysobjects
where id = object_id('term') and type = 'U') drop table term go
if exists (select 1
from sysobjects
where id = object_id('xueyear') and type = 'U') drop table xueyear go
if exists (select 1
from sysobjects
where id = object_id('xykcgl')
- 9 -
and type = 'U') drop table xykcgl go
/*==============================================================*/ /* Table: cla */
/*==============================================================*/ create table cla (
clano varchar(10) not null, clana varchar(40) not null, constraint PK_CLA primary key nonclustered (clano) ) go
/*==============================================================*/ /* Table: col */
/*==============================================================*/ create table col (
colno varchar(10) not null, colna varchar(40) not null, constraint PK_COL primary key nonclustered (colno) ) go
数据库原理实验报告
- 10 -
/*==============================================================*/ /* Table: jcxm */
/*==============================================================*/ create table jcxm (
jxno varchar(10) not null, jxna varchar(60) not null, constraint PK_JCXM primary key nonclustered (jxno) ) go
/*==============================================================*/ /* Table: ltest */
/*==============================================================*/ create table ltest (
ltestno varchar(10) not null, ltestna varchar(20) not null, testtime float not null, constraint PK_LTEST primary key nonclustered (ltestno) ) go
/*==============================================================*/ /* Table: maj */
/*==============================================================*/
数据库原理实验报告
- 11 -