1
Vote

How to sort tree data for Tables, Procedures, Vies and Functions

description

To have the tree sorted for Tables, Procedures, Vies and Functions,
edit resource file DALResources.resx and make 4 changes.
  1. GetTablesSqlCommand add ORDER BY TABLE_NAME at end
  2. GetStoredProcedureSqlCommand add ORDER BY ROUTINE_NAME at end
  3. GetViewsSqlCommand add ORDER BY TABLE_NAME at end
  4. GetFunctionsSqlCommand add ORDER BY ROUTINE_NAME at end
Regards
Tony

comments