是否可以像在oracle中一样在SQL Server 2008中为索引名重新编制索引. [英] is it possible to reindexing column names in SQL Server 2008 as we do in oracle.

问题描述

是否可以像在oracle中一样为SQL Server 2008中的索引名重新建立索引.
我们可以更改已经创建的表中的列顺序吗?
像:

表名到表名
Column1，column2，Column3，.... Column3，Column1，Column2，.....

如果可能，那么如何，如果不能，那么为什么不可能，请给出原因的解决方案

回复很快.紧急

提前致谢.

is it possible to reindexing column names in SQL Server 2008 as we do in oracle.
can we alter columns order in already created table.
like:

Table_Name to Table_Name
Column1,column2,Column3,.... Column3,Column1,Column2,........

if is it possible then how and if not then why is it not possible, plz give solution with reason

Reply Fast. Its urgent

Thanks in Advance.

推荐答案

是的.有可能.

转到表格设计.
然后选择要移动的列.
拖放到新位置.

Yeah. Its possible.

Go to table design.
Then select the column you want to move.
Drag and drop to your new place.

尽管可以在Management Studio中更改列的顺序，但无需这样做.从SQL的角度来看，列的顺序无关紧要.那么，为什么要尝试这样做呢?也许是因为其他问题?

Although it''s possible to change the order of columns in Management Studio, there should be no need to do this. From SQL point of view the order of columns doesn''t matter. So why are you trying to do this? Perhaps because of some other problem?

这篇关于是否可以像在oracle中一样在SQL Server 2008中为索引名重新编制索引.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！