
复制-- ============================================= -- Basic Create Database Template -- ============================================= IF EXISTS (SELECT * FROM master..sysdatabases WHERE name = Nsuntest) DROP DATABASE suntest GO CREATE DATABASE suntest on 建数据库 primary ( name = suntest_data, filename = e:\suntest_data.mdf, size = 3, maxsize = 10, filegrowth = 10% ), filegroup newgroup1 ( name = suntest_data, filename = e:\suntest_data.mdf, size = 3, maxsize = 10, filegrowth = 1 ) log on ( name=suntest_log, filename=e:\suntest_log.mdf, size=1, maxsize=6, filegrowth=1 ) GO 1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.25.26.27.28.29.30.31.32.33.34.35.36.