SQL2005 代码解析

来源：百度知道 编辑：UC知道 时间：2024/06/30 19:06:37
CREATE DATABASE SCHOOL
ON PRIMARY
(
NAME=school1,
FILENAME='D:\school\school1.mdf',
SIZE=10,
MAXSIZE=50,
FILEGROWTH=10%
),
(
NAME=SCHOOL2,
FILENAME='D:\school\school2.NDF',
SIZE=10,
MAXSIZE=50,
FILEGROWTH=10%
),
FILEGROUP STUDENTS
(
NAME=STUDENTS1,
FILENAME='D:\school\STUDENTS1.NDF',
SIZE=10,
MAXSIZE=50,
FILEGROWTH=10%
),
(
NAME=STUDENTS2,
FILENAME='D:\school\STUDENTS2.NDF',
SIZE=10,
MAXSIZE=50,
FILEGROWTH=10%
),
FILEGROUP TEACHERS
(
NAME=TEACHERS1,
FILENAME='D:\school\TEACHERS1.NDF',
SIZE=10,
MAXSIZE=50,
FILEGROWTH=10%
),
(
NAME=TEACHERS2,
FILENAME='D:\school\TEACHERS2.NDF',
SIZE=10,
MAXSIZE=50,
FILEGROWTH=10%
),