Having left CodeGear back in July and having now been out in the “real world” doing consulting for awhile I’m wondering what do MS SQL developers use to explore a SQL server database?
If you’re answer is SQL Server Management Studio (SSMS) that’s not what I’m looking for and I find it really lacking in numerous areas. I’m looking for something that includes things like:
- Ability to view details of a table’s structure (column types, size etc.) without having to “design” the table
- Ability to view the details of a foreign keys without having to “design” the table
- Provide a “favorites” list where I can tag any entity in the DB as a “favorite”
- Context menus that include a Copy command for selected items like table names, SPROCs etc.
- A real Properties window unlike SSMS which displays properties of whatever the selected item is not just what’s in one window. Server explorer in VS.NET works the way I’d like but it’s missing on a table for keys, constraints, triggers, indexes…
- Counts of objects (tables, fields, indices etc.)
The system I’m working has 100’s of tables, SPROCs etc. and is large which makes spelunking slow and tedious. I know Delphi includes the Database Explorer but that requires a full Delphi license and while I have a licensed copy I don’t want to install the entire IDE just for that.
So, what do you use?