Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

SQL Server Managment Studio Object Explorer and Table

0 views
Skip to first unread message

PSULionRP

unread,
Aug 21, 2007, 9:50:03 AM8/21/07
to
Within SQL Server Managment Studio and Object Explorer, you can explore
Tables. But unlike Enterprise Manager, it doesn't seem as though you can
right-click on the table and query it and sort it. My biggest problem is how
can you sort a table within Object Explorer in SQL Server Management Studio???

Thanks in advance for the help.

PSULionRP

Carlos Sacristan

unread,
Aug 21, 2007, 9:53:05 AM8/21/07
to
And why within Object Explorer, when you have the possibility to write
the sentence as you like in a new query?

"PSULionRP" <PSUL...@discussions.microsoft.com> escribió en el mensaje
news:01A6C180-64BE-4919...@microsoft.com...

Uri Dimant

unread,
Aug 21, 2007, 9:55:13 AM8/21/07
to
Hi
Navigate to the database and then click on Tables folder. On the right pane
(Object Explore Details) you will see all tables. By click on fixed column
(Name) you can sort them. If I remeber well you should install SP2

"PSULionRP" <PSUL...@discussions.microsoft.com> wrote in message
news:01A6C180-64BE-4919...@microsoft.com...

PSULionRP

unread,
Aug 21, 2007, 10:00:02 AM8/21/07
to
I figured it out.

Open the table, right click on Pane and choose Crteria. That will allow you
to sort the table.

Aaron Bertrand [SQL Server MVP]

unread,
Aug 21, 2007, 12:55:53 PM8/21/07
to
Open a new query window, type SELECT * FROM table ORDER BY column, and hit
F5


"PSULionRP" <PSUL...@discussions.microsoft.com> wrote in message
news:01A6C180-64BE-4919...@microsoft.com...

0 new messages