面向对象软件工程与UML 教学课件 作者 张京 租赁房的代码预览.doc
文本预览下载声明
（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
显示全部