第3章SQL语言基础及数据定义功能报告.ppt

示例2 CREATE DATABASE RShDB ON ( NAME = RShDB, FILENAME = D:\RShDB_Data\RShDB.mdf , SIZE = 10, MAXSIZE = 30, FILEGROWTH = 5 ) LOG ON ( NAME = RShDB_log, FILENAME = D:\RShDB_Data\RShDB_log.ldf , SIZE = 3, MAXSIZE = 12, FILEGROWTH = 2 ) 示例3 CREATE DATABASE students ON PRIMARY ( NAME = students, FILENAME = F:\Data\students.mdf, SIZE = 3MB, MAXSIZE = UNLIMITED ), ( NAME = students_data1, FILENAME = D:\Data\students_data1.ndf, SIZE = 5MB, MAXSIZE = 10MB, FILEGROWTH = 1MB ) LOG ON ( NAME = students_log, FILENAME = F:\Data\students_log.ldf,