汽车租赁公司CIS数据库系统的设计[8]

[入库:2005年8月18日] [更新:2007年3月24日]

本文简介:选择自 lastking 的 blog

if exists (select * from dbo.sysobjects where id = object_id(n'[dbo].[fk_reserve_info_client_info]') and objectproperty(id, n'isforeignkey') = 1)

alter table [dbo].[reserve_info] drop constraint fk_reserve_info_client_info

go

 

/****** object:  table [dbo].[reserve_info]    script date: 2004-9-11 14:41:48 ******/

if exists (select * from dbo.sysobjects where id = object_id(n'[dbo].[reserve_info]') and objectproperty(id, n'isusertable') = 1)

drop table [dbo].[reserve_info]

go

 

/****** object:  table [dbo].[car_info]    script date: 2004-9-11 14:41:48 ******/

if exists (select * from dbo.sysobjects where id = object_id(n'[dbo].[car_info]') and objectproperty(id, n'isusertable') = 1)

drop table [dbo].[car_info]

go

 

/****** object:  table [dbo].[client_info]    script date: 2004-9-11 14:41:48 ******/

if exists (select * from dbo.sysobjects where id = object_id(n'[dbo].[client_info]') and objectproperty(id, n'isusertable') = 1)

drop table [dbo].[client_info]

go

 

/****** object:  table [dbo].[price_info]    script date: 2004-9-11 14:41:48 ******/

if exists (select * from dbo.sysobjects where id = object_id(n'[dbo].[price_info]') and objectproperty(id, n'isusertable') = 1)

drop table [dbo].[price_info]

go

 

/****** object:  table [dbo].[provider_info]    script date: 2004-9-11 14:41:48 ******/

if exists (select * from dbo.sysobjects where id = object_id(n'[dbo].[provider_info]') and objectproperty(id, n'isusertable') = 1)

drop table [dbo].[provider_info]

go

 

本文关键:汽车租赁公司CIS数据库系统的设计
 

本站最佳浏览方式为 分辨率 1024x768 IE 6.0(或更高版本的 IE浏览器)

go top