这样建索引有问题么？

Question

create index A on tableA(name, id);
create index B on tableA(name, id);B可以创建成功么？

Answer 1

create table tablea(name varchar,id int)create index A on tableA(name, id);
create index B on tableA(name, id);sp_helpindex tablea
/*
index_name                                                                                                                       index_description                                                                                                                                                                                                  index_keys                                                                                                                                                                                                                                                       
-------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 
A                                                                                                                                nonclustered located on PRIMARY                                                                                                                                                                                    name, id
B                                                                                                                                nonclustered located on PRIMARY                                                                                                                                                                                    name, id

Answer 2

事实上是要给索引A创建一个别名，但是别人提供的SQL却是第二句，所有就这么问问题了。
可以说一下怎么样给A创建别名B么?

Answer 3

05的好像有创建同意词的,CREATE SYNONYM查查

Answer 4

create synonym b for a