面向对象软件工程与UML 教学课件 作者 张京 租赁房的代码预览.docVIP

（5）租赁房的代码预览。 alter table TenancyBargin drop constraint FK_TENANCYB_C_TENANCY_TENANCYH go if exists (select 1 from sysindexes where id = object_id(TenancyHouse) and name = C_Tenancy_FK and indid 0 and indid 255) drop index TenancyHouse.C_Tenancy_FK go if exists (select 1 from sysobjects where id = object_id(TenancyHouse) and type = U) drop table TenancyHouse go /*==============================================================*/ /* Table: TenancyHouse */ /*==============================================================*/ create table TenancyHouse ( TenancyID char(10) not null, TenancyAdd text null, TenancyInt text null, TenencyMon numeric(10,2) null, constraint PK_TENANCYHOUSE primary key (TenancyID) ) go /*==============================================================*/ /* Index: C_Tenancy_FK */ /*==============================================================*/ create index C_Tenancy_FK on TenancyHouse ( TenancyID ) go alter table TenancyBargin drop constraint FK_TENANCYB_HOUSEHOST_HOUSEHOS go alter table TenancyBargin drop constraint FK_TENANCYB_C_TENANCY_TENANCYH go if exists (select 1 from sysindexes where id = object_id(TenancyBargin) and name = Person_Contract_FK and indid 0 and indid 255) drop index TenancyBargin.Person_Contract_FK go if exists (select 1 from sysindexes where id = object_id(TenancyBargin) and name = HouseHost_Contract_FK and indid 0