if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[图书丢失_图书编号_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[图书丢失] DROP CONSTRAINT 图书丢失_图书编号_fk
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_图书罚款_图书信息]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[图书罚款] DROP CONSTRAINT FK_图书罚款_图书信息
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[图书归还_图书编号_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[图书归还] DROP CONSTRAINT 图书归还_图书编号_fk
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[图书借阅_图书编号_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[图书借阅] DROP CONSTRAINT 图书借阅_图书编号_fk
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_图书征订_图书信息]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[图书征订] DROP CONSTRAINT FK_图书征订_图书信息
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[图书注销_图书编号_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[图书注销] DROP CONSTRAINT 图书注销_图书编号_fk
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[期刊丢失_期刊编号_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[期刊丢失] DROP CONSTRAINT 期刊丢失_期刊编号_fk
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_期刊罚款_期刊信息]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[期刊罚款] DROP CONSTRAINT FK_期刊罚款_期刊信息
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_期刊罚款_读者信息]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[期刊罚款] DROP CONSTRAINT FK_期刊罚款_读者信息
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_图书罚款_读者信息]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[图书罚款] DROP CONSTRAINT FK_图书罚款_读者信息
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_读者信息_读者类型]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[读者信息] DROP CONSTRAINT FK_读者信息_读者类型
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sf_图书借阅]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sf_图书借阅]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sf_图书归还]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sf_图书归还]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sf_图书征订]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sf_图书征订]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[书架]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[书架]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[供应商]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[供应商]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[出版社]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[出版社]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[图书丢失]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[图书丢失]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[图书信息]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[图书信息]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[图书借阅]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[图书借阅]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[图书归还]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[图书归还]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[图书征订]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[图书征订]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[图书注销]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[图书注销]
GO
if exi�
没有合适的资源?快使用搜索试试~ 我知道了~
bdd.rar_bdd_数据库课程设计
共59个文件
vb:15个
bmp:13个
resx:12个
1.该资源内容由用户上传,如若侵权请联系客服进行举报
2.虚拟产品一经售出概不退款(资源遇到问题,请及时私信上传者)
2.虚拟产品一经售出概不退款(资源遇到问题,请及时私信上传者)
版权申诉
0 下载量 93 浏览量
2022-09-24
00:18:07
上传
评论
收藏 597KB RAR 举报
温馨提示
数据库课程设计。
资源推荐
资源详情
资源评论
收起资源包目录
bdd.rar (59个子文件)
图书馆代码
代码
DataSet1.xsd 8KB
图书管理系统.vbproj 9KB
frmSelectBook.resx 10KB
frmBookType.vb 15KB
frmList.resx 6KB
bin
图书管理系统.pdb 646KB
图书管理系统.pd_ 61KB
frmBookDoc.resx 28KB
图书管理系统.vbproj.user 2KB
图书管理系统.sln 909B
image
删除.bmp 246B
上记录.bmp 246B
搜索.bmp 246B
关闭.bmp 246B
尾记录.bmp 246B
取消.bmp 246B
保存.bmp 246B
计算.bmp 246B
lib.ICO 1KB
修改.bmp 246B
Thumbs.db 17KB
下记录.bmp 246B
首记录.bmp 246B
查询选择.bmp 246B
新增.bmp 246B
frmBookType.resx 16KB
frmMoney.vb 19KB
frmReturn.vb 8KB
DataBase.vb 2KB
工程1.vbp 644B
frmBorrow.vb 20KB
frmBookDoc.vb 44KB
frmReaderType.resx 19KB
frmBuyBook.resx 26KB
frmMain.vb 9KB
frmReaderType.vb 21KB
图书管理系统.suo 10KB
frmBase.resx 24KB
lib.ICO 1KB
MSSCCPRJ.SCC 190B
frmReturn.resx 8KB
frmMoney.resx 15KB
DataSet1.vb 126KB
frmSelectBook.vb 11KB
DataSet1.xsx 165B
frmBorrow.resx 25KB
工程1.vbw 31B
frmReaderDoc.resx 29KB
frmBase.vb 15KB
frmMain.resx 14KB
frmList.vb 4KB
frmBuyBook.vb 36KB
frmReaderDoc.vb 43KB
AssemblyInfo.vb 809B
建库脚本
libbook.mdf 2.13MB
libbook_log.ldf 1024KB
libbook.bak 1.83MB
图书馆管理系统.sql 38KB
www.pudn.com.txt 218B
共 59 条
- 1
资源评论
刘良运
- 粉丝: 68
- 资源: 1万+
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功