日期:2014-05-17 浏览次数:20438 次
create table dds
(c1 int not null,
c2 int not null
constraint pk_dds primary key nonclustered (c1)
)
create clustered index ix_dds_c2 on dds(c2)
sp_helpindex dds
/*
index_name index_description index_keys
------------------ ------------------------------------------------------ --------------
ix_dds_c2 clustered located on PRIMARY c2
pk_dds nonclustered, unique, primary key located on PRIMARY c1
*/