|
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, --I would like to ask whether the index is added to the file group secondary, or is this table placed in the secondary?
col2 int
) |
|