关于数据库文件组的问题
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
)
[解决办法]
主键约束.