有关主键设置问题

Question

CREATE TABLE [dbo].[TankiHosyoTaisyo](
[ChosaKukanNo]                   [varchar](50)      COLLATE Japanese_CI_AS NOT  NULL,
[Jimusyo]                        [varchar](2)       COLLATE Japanese_CI_AS      NULL,
[RoadType]                       [smallint]                                     NULL,
[RosenNo]                        [numeric](3, 0)                                NULL,
        [Sokuteiti_Tawamiryou_10]        [numeric](6, 2)                                NULL,
CONSTRAINT [PK_TankiHosyoTaisyo] PRIMARY KEY CLUSTERED 
(
[ChosaKukanNo] ASC
)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
);麻烦师兄些指点下红色字体的那段代码的意思，特别是后面WITH的部分~~不清楚什么意思~~

Answer 1

CONSTRAINT [PK_TankiHosyoTaisyo] PRIMARY KEY CLUSTERED
(
[ChosaKukanNo] ASC
)
定義聚集索引主健with主健索引選項說明
http://technet.microsoft.com/zh-cn/library/ms188677(SQL.90).aspx