ylbtech-DatabaseDesgin:Microsoft-PetSop4.0(宠物商店)-数据库设计-Sql |
DatabaseName:PetShop(宠物商店)
Model:宠物商店网站
Type:专业网站
1.A,数据库关系图(Database Diagram)返回顶部 |
1.B,数据库设计脚本(Database Design Script) - 批处理创建数据返回顶部 |
1.B.1,Creating Database...
1.B.1.1,Sql/CreateDatabase1.sql
USE [master]; CREATE DATABASE [MSPetShop4];
1.B.1.2,Sql/CreateDatabase2.sql
USE [master] CREATE DATABASE [MSPetShop4Orders]
1.B.1.3,Sql/CreateDatabase3.sql
USE [master] CREATE DATABASE [MSPetShop4Profile]
1.B.2,Configuring Logins...
1.B.2.1,Sql/CreateDBLogin1.sql
![](https://images.cnblogs.com/OutliningIndicators/ContractedBlock.gif?x-oss-process=image/resize,w_1400/format,webp)
1.B.2.2,Sql/CreateDBLogin2.sql
![](https://images.cnblogs.com/OutliningIndicators/ContractedBlock.gif?x-oss-process=image/resize,w_1400/format,webp)
1.B.2.3,Sql/CreateDBLogin3.sql
![](https://images.cnblogs.com/OutliningIndicators/ContractedBlock.gif?x-oss-process=image/resize,w_1400/format,webp)
1.B.2.4,Sql/CreateDBLogin4.sql
![](https://images.cnblogs.com/OutliningIndicators/ContractedBlock.gif?x-oss-process=image/resize,w_1400/format,webp)
1.B.3,Creating Tables...
1.B.3.1, Sql/CreateTables1.sql
![](https://images.cnblogs.com/OutliningIndicators/ContractedBlock.gif?x-oss-process=image/resize,w_1400/format,webp)
1.B.3.2, Sql/CreateTables2.sql
![](https://images.cnblogs.com/OutliningIndicators/ContractedBlock.gif?x-oss-process=image/resize,w_1400/format,webp)
1.B.3.3, Sql/CreateTables3.sql
![](https://images.cnblogs.com/OutliningIndicators/ContractedBlock.gif?x-oss-process=image/resize,w_1400/format,webp)
1.B.4,Loading Data...
1.B.4.1,Sql/LoadTables1.sql
![](https://images.cnblogs.com/OutliningIndicators/ContractedBlock.gif?x-oss-process=image/resize,w_1400/format,webp)
1.C,数据库设计脚本(Database Design Script) - 批处理删除数据返回顶部 |
1.C.1,Uninstalling Database...
1.C.1.1, Sql/CreateTables1.sql
![](https://images.cnblogs.com/OutliningIndicators/ContractedBlock.gif?x-oss-process=image/resize,w_1400/format,webp)
1.C.1.2, Sql/CreateTables2.sql
![](https://images.cnblogs.com/OutliningIndicators/ContractedBlock.gif?x-oss-process=image/resize,w_1400/format,webp)
1.C.1.3, Sql/CreateTables3.sql
![](https://images.cnblogs.com/OutliningIndicators/ContractedBlock.gif?x-oss-process=image/resize,w_1400/format,webp)
1.C.1.4, Sql/CreateTables3.sql
![](https://images.cnblogs.com/OutliningIndicators/ContractedBlock.gif?x-oss-process=image/resize,w_1400/format,webp)
D,? 这两个在批处理是怎么处理的
?D.1, Sql/CreateDemoUsers.sql
![](https://images.cnblogs.com/OutliningIndicators/ContractedBlock.gif?x-oss-process=image/resize,w_1400/format,webp)
?D.2, Sql/DropDBLogin.sql
![](https://images.cnblogs.com/OutliningIndicators/ContractedBlock.gif?x-oss-process=image/resize,w_1400/format,webp)
本文转自ylbtech博客园博客,原文链接:http://www.cnblogs.com/ylbtech/p/4024030.html,如需转载请自行联系原作者