SSMS object explorer sorting order?

Question

I created the following schemas and hope their objects be shown at the bottom of object tree. However, they are on the top instead. Is there any special characters that be shown in the bottom in SSMS explorer tree?

create schema [~temp]
create schema [{temp}]

Shouldn't your schema name be something to give it some relevance instead of the placement in a list? — Sean Lange, Nov 15 '16 at 21:59
@SeanLange I want a schema name for these objects need to temporarily keep for a while before deleting. That's why I want it sink to the bottom. — ca9163d9, Nov 15 '16 at 22:03

score 2 · Accepted Answer · answered Nov 15 '16 at 22:27

2

You are asking for a character that sorts after z?

Take your pick from any of these

WITH T AS
(
SELECT TOP 65536 NCHAR(ROW_NUMBER() OVER (ORDER BY @@SPID)) AS C
FROM master..spt_values v1, 
     master..spt_values v2
)
SELECT *
FROM T 
WHERE C > 'Z'
ORDER BY C

For example

CREATE SCHEMA [Ξtemp]

or

CREATE SCHEMA [Жtemp]

would both work though not be convenient to type

answered Nov 15 '16 at 22:27

Martin Smith

438,706
87
741
845

You might need to use a lower case z depending on the collation of your database. – Sean Lange Nov 15 '16 at 22:35

score 0 · Answer 2 · edited May 23 '17 at 12:07

No, I don't believe you can.

What you could do though is filter it out completely; from

SQL Server Management Studio Schema View

In SSMS 2005 or 2008, right click on the heading: "Stored Procedures", "Tables", etc, then on "Filter Settings", then for the "Schema" change "Operator" to "Does not contain" or "Contains", etc and then set a Value to filter them...

I've just checked and it is still applicable in SSMS 2014

You would need to remember that is is there, though. Calendar reminder?

EDIT:

Ah, I miss-read the question. I was looking at other methods of ordering the list. I'll leave my answer here as an option, but I acknowledge it wasn't what you asked for.

SSMS object explorer sorting order?

2 Answers2