sqlserver图书管理系统分享.pdfVIP

dropdatabase book 创建数据库 createdatabase book On ( Name = TeachDataFile , Filename = T:\DataBaseProject\book.mdf , size = 30MB , Max size = 100MB , filegrowth = 5Mb ) log on ( name = TechLogFile , fileName =T:\DataBaseProject\book_log.ldf , size = 30mb , m axsize = 50mb , filegrowth =5mb ) 自动收缩 alterdatabase book set auto_shrink on 脱机 | 联机 alterdatabase book set offline alterdatabase book se