SSMS Table Order

Question

SSMS Table Order

lynn.huff

Right there with Babe

Points: 784
More actions
April 14, 2015 at 12:58 pm

#296890

Is there a way to show tables in alphabetical order when you expand the table node of a database from inside SSMS?
Forum Etiquette: How to post Reporting Services problems

[/url]

Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
[/url]

How to Post Performance Problems - by Gail Shaw
[/url]

mister.magoo SSC-Forever Points: 47174 More actions · Answer 1

Click on the Tables node, then press F7 to open the Object Explorer Details window, where you can sort by any available field, including name.

MM

select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

lynn.huff Right there with Babe Points: 784 More actions · Answer 2

I know you can see them that way in Object Explorer Details, but is there any way to change the default sort order of tables in Object Explorer (left pane) from chronological by creation time to alphabetical. Would be a nice feature.

lynn.huff Right there with Babe Points: 784 More actions · Answer 3

lynn.huff

Right there with Babe

Points: 784

April 14, 2015 at 2:40 pm

#1790958

Never mind. I'm have a senior moment.