create table tbb(id int ,name varchar(10)) alter table tbb alter column id int not null alter table tbb add constraint pk_id primary key(id) create index ix_id_name on tbb(id) include (name)
如果你在主键pk_id 增加 include (name) 试试?哈哈,不行了吧? 前提是主键不能为默认生成聚集索引。
create table tbb(id int ,name varchar(10)) alter table tbb alter column id int not null alter table tbb add constraint pk_id primary key nonclusteRED(id) create index ix_id_name1 on tbb(id) include (name)
alter table tbb alter column id int not null
alter table tbb add constraint pk_id primary key(id)
create index ix_id_name on tbb(id) include (name)
前提是主键不能为默认生成聚集索引。
create table tbb(id int ,name varchar(10))
alter table tbb alter column id int not null
alter table tbb add constraint pk_id primary key nonclusteRED(id)
create index ix_id_name1 on tbb(id) include (name)
内有例子与【图片解析】