Activity overview
Latest activity by eswise
The reason it was getting to me was because I opened up a "very bad" database that I am supporting. We're talking over 420 tables with only probably about 70 in use (many are temp tables that they never cleaned up but some actually are in use and the app is all ad-hoc sql in the application so it's difficult to tell whether dropping these tables will bust it or not... hence we haven't cleaned it up yet)
Anyways, being unfamiliar with the schema and pulling that many fields was a bit of a mindshock. You can call the table sort option "This is a crappy undocumented database" feature.
Come to think of it though, it'd be great if it would let you type your sql like it is executed and then reformat it. ie FROM <table1> inner join <table2> where blah select blah blah blah / comments
The reason it was getting to me was because I opened up a "very bad" database that I am supporting. We're talking over 420 tables with only probably about 70 in use (many are temp tables that they...
Order of fields in intellisense
I notice the default when you do a SELECT is to show the fields ordered by field names across all tables. I think for my purposes it would be more useful to be able to grab fields by tablename fir...