8-39.sql

sql2000工程实践一书第8张源代码

USE master
GO
CREATE DATABASE College
ON 
( NAME =college_Data,
   FILENAME = 'C:\college\college_Data.MDF',
   SIZE = 10,
   MAXSIZE = 50,
   FILEGROWTH = 5 )
LOG ON
( NAME = 'college_Log',
   FILENAME = 'C:\college\college_Log.LDF',
   SIZE = 5MB,
   MAXSIZE = 25MB,
   FILEGROWTH = 5MB )
GO