<div>
What exactly you mean by category ? <br />
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 <br />
<br />
SELECT * <br />
FROM INFORMATION_SCHEMA.TABLES<br />
ORDER BY Table_Name <br />

</div>


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 *
FROM INFORMATION_SCHEMA.TABLES
ORDER BY Table_Name


<div>
Use the ORDER BY statement.<br />
<br />
Lee
</div>


<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
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?
</div>
</div>


Hi,

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?

SQL Tables

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.