（5）租赁房的代码预览。alter table TenancyBargin drop constraint FK_TENANCYB_C_TENANCY_TENANCYHgoif exists (select 1 from sysindexes where id = object_id(TenancyHouse) and name = C_Tenancy_FK and indid 0 and indid 0 and indid 0 and indid 255) drop index TenancyBargin.HouseHost_Contract_FKgoif exists (select 1 from sysobjects where id = object_id(TenancyBargin) and type = U) drop table TenancyBargingo/*=*/* Table: TenancyBargin */*=*/create table TenancyBargin ( BarginID char(10) not null, yid char(18) not null, TenancyID char(10) not null, jID char(10) not null, BarginMoney numeric(10,2) null, StartTime datetime null, StopTime datetime null, constraint PK_TENANCYBARGIN primary key (BarginID)go/*=*/* Index: Person_Contract_FK */*=*/create index Person_Contract_FK on TenancyBargin (yid)go/*=*/* Index: HouseHost_Contract_FK */*=*/create index HouseHost_Contract_FK on TenancyBargin (jID)goalter table TenancyBargin add constraint FK_TENANCYB_PERSON_CO_PERMSG foreign key (yid) references PerMsg (yid)goalter table TenancyBargin add constraint FK_TENANCYB_HOUSEHOST_HOUSEHOS foreign key (jID) references HouseHost (jID)goalter table TenancyBargin add constraint FK_TENANCYB_C_TENANCY_TENANCYH foreign key (TenancyID) references TenancyHouse (TenancyID)go