SQL Tables

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?
monarchitAsked:
Who is Participating?
 
monarchitAuthor Commented:
Case closed
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
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
0
 
Lee SavidgeCommented:
Use the ORDER BY statement.

Lee
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.