Home
Options

How are tables sorted in Explorer Panel?

flipdoubtflipdoubt

Tables in my Explorer Panel are "kinda" in alphabetical order, but not exactly, and refresh (SHIFT+ALT+D) does not re-sort them. Is there any way to force a re-sort? What determines the sort order now?

Here is a sample of how LinqPad sorts my tables:

· Share on FacebookShare on Twitter

Comments

  • Options
    JoeAlbahariJoeAlbahari

    I'm not sure what would cause that. Can you post the SQL schema to reproduce?

    · Share on FacebookShare on Twitter
  • Options
    flipdoubtflipdoubt

    When you ask for the SQL schema, are you asking me to post the "CREATE TABLE" statements? We use a SQL Database project to produce the database, and the script for a new database ends up being 14,000 lines and owned by my employer. Can we narrow the scope of what you want me to share?

    I can tell you that the CREATE TABLE Users line occurs on line 2792 of the script whereas the CREATE TABLE ChangeMessages line occurs on line 2011.

    · Share on FacebookShare on Twitter
  • Options
    JoeAlbahariJoeAlbahari

    Are you able to provide the minimum CREATE DATABASE / CREATE TABLE statements required to reproduce the problem?

    · Share on FacebookShare on Twitter
Sign In or Register to comment.