SQL Tables

Posted on 2010-01-07
Last Modified: 2012-05-08

When i open a table in SQL studio. How can i sort the information that is displayed. Example, i want to sort the tables by category?
Question by:monarchit
    LVL 75

    Expert Comment

    by:Aneesh Retnakaran
    What exactly you mean by category ?
    i dont really think there is an option to sort in the ssms. if you need some sort of sorting, you can run a query like this

    SELECT *
    ORDER BY Table_Name
    LVL 25

    Expert Comment

    by:Lee Savidge
    Use the ORDER BY statement.


    Accepted Solution

    Case closed

    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    Join & Write a Comment

    Recently, when I was asked to create a new SQL 2005 cluster, Microsoft released a new service pack for MS SQL 2005 what is Service Pack 3. When I finished the installation of MS SQL 2005 I found myself troubled why the installation of SP3 failed …
    Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
    how to add IIS SMTP to handle application/Scanner relays into office 365.

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    24 Experts available now in Live!

    Get 1:1 Help Now