No, there is no such functionality.


On 2/24/09 8:31 AM, in article efXZG#FiJHA.760 (AT) TK2MSFTNGP03 (DOT) phx.gbl,
"Oriane" <oriane (AT) noemail (DOT) noemail> wrote:

(Also can you please fix your system clock; it is not 2/24 in any part of
the world I'm aware of...)


On 2/24/09 8:31 AM, in article efXZG#FiJHA.760 (AT) TK2MSFTNGP03 (DOT) phx.gbl,
"Oriane" <oriane (AT) noemail (DOT) noemail> wrote:

Hi Aaron,
"Aaron Bertrand [SQL Server MVP]" <ten.xoc (AT) dnartreb (DOT) noraa> a écrit dans le
message de news:C5B1B2E8.EABC%ten.xoc (AT) dnartreb (DOT) noraa...
(when the column is alreday filled with data) ?

Thank you (I have reset the system clock :-)).

You just can sort columns alphabetically (ascending or descenting) using
SSMS' s Object Explorer Details.

--
Ekrem Önsoy



"Oriane" <oriane (AT) noemail (DOT) noemail> wrote

Hi Ekrem,
"Ekrem Önsoy" <ekrem (AT) compecta (DOT) com> a écrit dans le message de
news:910A0F22-C24B-4818-90DF-A7817B783105 (AT) microsoft (DOT) com...

Best regards

Oriane (oriane (AT) noemail (DOT) noemail) writes:
If you want to change the table definition to reflect the desired order,
you will have to go the long road, and create a new table, migrate
data over, move referencing foreign keys etc. Certainly an advanced
operation, which requires good understanding of what you are doing.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

Open up SSMS and connect to your SQL Server instance.

Then expand Databases node and at the right side, you'll see Object Explorer
Details tab by default. If it's not open, then you can use View -> Object
Explorer Details menu to open it. In this tab, you'll find column headers
such as "Name" and when you click on this column header once, you'll see
that it'll sort the items by their names and if you click again, it'll sort
them descending.

--
Ekrem Önsoy



"Oriane" <oriane (AT) noemail (DOT) noemail> wrote

Hi Ekrem,

You made me discover something !

Thanks

Hi Oriane,
Thank you for using Microsoft MSDN Managed Newsgroup. My name is Mark Han.
I am glad to work with you on this issue.

From your description, I understand that you would like to sort the column
as the following. display first the primary, unique and foreign keys
columns and then display the rest as alphabetically sorted. If I have
misunderstood, please let me know.

Based on my research, it seems that there is no such function to meet your
requirement. However we can display the columns alphabetically in SQL 2008

Besides, I have apply your requirement to our dev team, if anything
updated, i will public it.

If there is anything unclear, please do not hesitate to let me know.

Have a nice day.

Best regards,
Mark Han
Microsoft Online Community Support
================================================== =========
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg (AT) microsoft (DOT) com.
================================================== =========
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscripti...ult.aspx#notif
ications.

Note: MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or
a Microsoft Support Engineer within 2 business day is acceptable. Please
note that each follow up response may take approximately
2 business days as the support professional working with you may need
further investigation to reach the most efficient resolution.
The offering is not appropriate for situations that require urgent,
real-time or phone-based interactions. Issues of this nature are
best handled working with a dedicated Microsoft Support Engineer by
contacting Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/en-us/subs.../aa948874.aspx

================================================== ==========
This posting is provided "AS IS" with no warranties, and conf

Enjoy it mate =)

--
Ekrem Önsoy



"Oriane" <oriane (AT) noemail (DOT) noemail> wrote