🚀 go-pugleaf

ON { <partition_scheme> | filegroup | "default" } 
Specifies the partition scheme or filegroup on which the table is stored. If 
<partition_scheme> is specified, the table is to be a partitioned table 
whose partitions are stored on a set of one or more filegroups specified in 
<partition_scheme>. If filegroup is specified, the table is stored in the 
named filegroup. The filegroup must exist within the database. If "default" 
is specified, or if ON is not specified at all, the table is stored on the 
default filegroup. The storage mechanism of a table as specified in CREATE 
TABLE cannot be subsequently altered.

ON {<partition_scheme> | filegroup | "default"} can also be specified in a 
PRIMARY KEY or UNIQUE constraint. These constraints create indexes. If 
filegroup is specified, the index is stored in the named filegroup. If 
"default" is specified, or if ON is not specified at all, the index is 
stored in the same filegroup as the table. If the PRIMARY KEY or UNIQUE 
constraint creates a clustered index, the data pages for the table are 
stored in the same filegroup as the index. If CLUSTERED is specified or the 
constraint otherwise creates a clustered index, and a <partition_scheme> is 
specified that differs from the <partition_scheme> or filegroup of the 
table definition, or vice-versa, only the constraint definition will be 
honored, and the other will be ignored. 


book on-line
 �� �� leonwzm 
( �Ÿ�) �Ĵ������ᵽ: ��: ����: CREATE TABLE ... : ( : ... : ) ON [PRIMARY]


--
http://bbs.sjtu.edu.cn/file/volunteers/1162217779160660.JPG

�� ��Դ:����ˮ˼Դ bbs.sjtu.edu.cn��[FROM: 59.78.51.51]