數(shù)據(jù)庫課程設(shè)計-學(xué)生成績管理系統(tǒng)(編輯修改稿)
2025-02-12 03:15 本頁面
【文章內(nèi)容簡介】 did 255) drop index goif exists (select 1 from sysindexes where id = object_id(39。課程表39。) and name = 39。Relationship_1_FK39。 and indid 0 and indid 255) drop index goif exists (select 1 from sysindexes where id = object_id(39。課程表39。) and name = 39。Relationship_6_FK39。 and indid 0 and indid 255) drop index goif exists (select 1 from sysobjects where id = object_id(39。Relationship_239。) and type = 39。U39。) drop table Relationship_2goif exists (select 1 from sysobjects where id = object_id(39。學(xué)生39。) and type = 39。U39。) drop table 學(xué)生goif exists (select 1 from sysobjects where id = object_id(39。學(xué)生成績表39。) and type = 39。U39。) drop table 學(xué)生成績表goif exists (select 1 from sysobjects where id = object_id(39。教師39。) and type = 39。U39。) drop table 教師goif exists (select 1 from sysobjects where id = object_id(39。管理員39。) and type = 39。U39。) drop table 管理員goif exists (select 1 from sysobjects where id = object_id(39。課程表39。) and type = 39。U39。) drop table 課程表go/*==============================================================*//* Table: Relationship_2 *//*==============================================================*/create table Relationship_2 ( sno numeric(10) not null, o numeric(10) not null, constraint PK_RELATIONSHIP_2 primary key (sno, o))go/*==============================================================*//* Index: Relationship_2_FK *//*==============================================================*/create index Relationship_2_FK on Relationship_2 (sno ASC)go/*==============================================================*//* Index: Relationship_3_FK *//*==============================================================*/create index Relationship_3_FK on Relationship_2 (o ASC)go/*=======================
范文總結(jié)相關(guān)推薦
鄂ICP備17016276號-1