數(shù)據(jù)庫(kù)課程設(shè)計(jì)教室管理信息系統(tǒng)(編輯修改稿)
2024-09-03 07:29 本頁(yè)面
【文章內(nèi)容簡(jiǎn)介】 d indid 255) drop index goif exists (select 1 from sysindexes where id = object_id(39。上課39。) and name = 39。上課3_FK39。 and indid 0 and indid 255) drop index goif exists (select 1 from sysindexes where id = object_id(39。上課39。) and name = 39。上課_FK39。 and indid 0 and indid 255) drop index goif exists (select 1 from sysindexes where id = object_id(39。學(xué)生39。) and name = 39。Relationship_2_FK39。 and indid 0 and indid 255) drop index goif exists (select 1 from sysindexes where id = object_id(39。學(xué)生39。) and name = 39。屬于_FK39。 and indid 0 and indid 255) drop index goif exists (select 1 from sysindexes where id = object_id(39。教室39。) and name = 39。位置于_FK39。 and indid 0 and indid 255) drop index goif exists (select 1 from sysindexes where id = object_id(39。教室借用39。) and name = 39。教室借用2_FK39。 and indid 0 and indid 255) drop index goif exists (select 1 from sysindexes where id = object_id(39。教室借用39。) and name = 39。教室借用_FK39。 and indid 0 and indid 255) drop index goif exists (select 1 from sysindexes where id = object_id(39。教師39。) and name = 39。隸屬于_FK39。 and indid 0 and indid 255) drop index goif exists (select 1 from sysobjects where id = object_id(39。Association_339。) and type = 39。U39。) drop table Association_3goif 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。學(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 教師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: Association_3 *//*==============================================================*/create table Association_3 ( 課程號(hào) char(10) not null, 教室編號(hào) char(10) not null, constraint PK_ASSOCIATION_3 primary key (課程號(hào), 教室編號(hào)))go/*==============================================================*//* Index: Association_3_FK *//*==============================================================*/create index Association_3_FK on Association_3 (課程號(hào) ASC)go/*==============================================================*//* Index: Association_4_FK *//*==========
范文總結(jié)相關(guān)推薦
鄂ICP備17016276號(hào)-1