MS SQL 创建文件组和在文件组上建表

CREATE DATABASE itcast
ON PRIMARY (
NAME = 'db_itcast1',
FILENAME = 'd:\db_itcast1.mdf',
SIZE = 3mb,
MAXSIZE = 5mb,
FILEGROWTH = 10% 
),
FILEGROUP itcast2_group(
NAME = 'db_itcast2',
FILENAME ='e:\db_itcast2.ndf',
SIZE = 3mb,
MAXSIZE = 5mb,
FILEGROWTH = 10%  
),
FILEGROUP itcast3_group(
NAME = 'db_itcast3',
FILENAME ='f:\db_itcast3.ndf',
SIZE = 3mb,
MAXSIZE = 5mb,
FILEGROWTH = 10%  
)

CREATE TABLE student(
id INT IDENTITY PRIMARY KEY,
stu_name VARCHAR(20) NOT NULL,
stu_no VARCHAR(20) NOT NULL 
) ON [itcast2_group]