>>Yes. You'll have to build your own tools. SSMS simply calls into the server to do it's work. Look at the SMO object.
>>
>>Note, there could be some third party tools available.
>
>TOAD comes to mind. Not nearly as complete as SSMS or Visual Studio though.
OTOH, much handier than SSMS. To mention just
- much better intellisense
- much more configurable - has to be, because it's basically the same engine as Toad for MySql, Oracle and whatnot, so it's a huge parser and code generator not specialized for one syntax but several of them, including the "which level of TSQL you want the scripts to be checked against / generated for?
- keeps multiple result sets
- query results are editable if you want, so it's your browse window too (do this with SSMS)
- generates better scripts than SSMS (I had to fix almost every second one when I carried it elsewhere, not so much with what Toad generates)
- table properties are in the main window, with one tab for each of table properties, columns (in a browse view, each column sortable, not just one fixed grid with a property sheet below), dependencies, constraints and, tada... script to generate the table with a bunch of options (include "if exist", include indexes etc etc) and the script is generated as soon as you take a look at it
- most of the tool windows are dockable or can float, so you can arrange them at will
- object explorer has three views (treeview, tabs, multiline tabs) so it's a lot of info at a small space, anything's there in 2-3 clicks.