I am using TOAD for SS 5.5 and would like to sort the object names in Database Explorer by object name, regardless of the schema. Currently, it sorts by schema and then by object name. Clicking the “Name” header only sorts the name within the schema.
In case it matters, I have the schema separated from the objects name and I am using the drop down method for viewing objects.
It also seems that I cannot get the schema back with the object name. In the Options under Explorer - General, there is no effect when I select “Sort list alphabetically when in drop-down mode” or “Separate schema or database by type (only for non treeview)”.
If I could sort the objects by Name and then by Schema, that would be great. TIA.