1.create database 商品資訊資料庫on primary(name=‘商品資訊資料庫",FILENAME="d:\商品資訊資料庫.mdf",size=10mb,maxsize=50mb,filegrowth=2mb)log on(name=‘商品資訊日誌",FILENAME="d:\商品資訊日誌.ldf",size=5mb,maxsize=25mb,filegrowth=1mb)2.create database Saleson primary(name=‘Sales_Data",FILENAME="d:\Sales_Data.mdf",size=20mb,maxsize=50mb,filegrowth=5%)Filegroup fg1(name=‘Sales_Data2",FILENAME="d:\Sales_Data2.ndf",size=20mb,maxsize=50mb,filegrowth=5%)log on(name=‘Sales_log",FILENAME="d:\Sales_log.ldf",size=10mb,maxsize=50mb,filegrowth=5mb)3.drop database 商品資訊資料庫drop database sales