图书馆管理系统建模设计

《图书馆管理系统建模设计》由会员上传分享，免费在线阅读，更多相关内容在工程资料-天天文库。

1、图书馆管理系统建模设计由PDM对象自动生成的数据库脚本文件代码如下：7ifexists(select1fromdbo.sysreferencesrjoindbo.sysobjectsoon(o.id=r.constidando.type='F')wherer.fkeyid=object_id('books')ando.name='FK_BOOKS_管理书籍_ADMIN')altertablebooksdropconstraintFK_BOOKS_管理书籍_ADMINgoifexists(select1fromdbo.sysreferencesrjoindb

2、o.sysobjectsoon(o.id=r.constidando.type='F')wherer.fkeyid=object_id('borrow_information')ando.name='FK_BORROW_I_BORROW_IN_BOOKS')altertableborrow_informationdropconstraintFK_BORROW_I_BORROW_IN_BOOKSgoifexists(select1fromdbo.sysreferencesrjoindbo.sysobjectsoon(o.id=r.constidando.ty

3、pe='F')wherer.fkeyid=object_id('borrow_information')ando.name='FK_BORROW_I_BORROW_IN_READER')altertableborrow_informationdropconstraintFK_BORROW_I_BORROW_IN_READERgoifexists(select1fromdbo.sysreferencesrjoindbo.sysobjectsoon(o.id=r.constidando.type='F')wherer.fkeyid=object_id('log

4、in')ando.name='FK_LOGIN_LOGIN_ADMIN')altertablelogindropconstraintFK_LOGIN_LOGIN_ADMINgoifexists(select1fromdbo.sysreferencesrjoindbo.sysobjectsoon(o.id=r.constidando.type='F')wherer.fkeyid=object_id('login')ando.name='FK_LOGIN_LOGIN2_READER')altertablelogin7dropconstraintFK_LOGIN

5、_LOGIN2_READERgoifexists(select1fromdbo.sysreferencesrjoindbo.sysobjectsoon(o.id=r.constidando.type='F')wherer.fkeyid=object_id('reversation')ando.name='FK_REVERSAT_REVERSATI_BOOKS')altertablereversationdropconstraintFK_REVERSAT_REVERSATI_BOOKSgoifexists(select1fromdbo.sysreferenc

6、esrjoindbo.sysobjectsoon(o.id=r.constidando.type='F')wherer.fkeyid=object_id('reversation')ando.name='FK_REVERSAT_REVERSATI_READER')altertablereversationdropconstraintFK_REVERSAT_REVERSATI_READERgoifexists(select1fromsysindexeswhereid=object_id('admin')andname='权限_FK'andindid>0and

7、indid<255)dropindexadmin.权限_FKgoifexists(select1fromsysobjectswhereid=object_id('admin')andtype='U')droptableadmingoifexists(select1fromsysindexeswhereid=object_id('books')andname='管理书籍_FK'andindid>0andindid<255)dropindexbooks.管理书籍_FKgoifexists(select1fromsysindexeswhereid=object_

8、id('books')7andname='图书类型_FK'andi