|
alter database Northwind
add filegroup SECONDARY
go
alter database northwind
add file
(name=scndr,
filename='f:\nthwndScnd',
size=1Mb,
maxsize=10Mb,
filegrowth=10%)
use northwind
go
CREATE TABLE tbl1
(col1 int CONSTRAINT pk_column01
PRIMARY KEY
WITH FILLFACTOR = 50
ON SECONDARY, --想问这里是索引添加---到文件组secondary,还是这个表格放在secondary呢?
col2 int
) |
|