|
|
|
|
|
SQL-Programmer 2.2 1 2 3 4 5 6 7 It then allows you to drill down even further and view the DDL for the corresponding object in the right pane.
Keeping with the theme of an explorer, you can view information on a variety of items related to the object you specified. For stored procedures, this brings up a very nice list showing all of the arguments or dependencies.
SFI has done an extremely good job of mimicking the Windows explorer. This provides a very intuitive interface to your database. But even with all of the normal features one thing that really stands out is the drag and drop support. Using the explorer, you can copy objects from one database to another via a simple drag and drop. When this is done, the dialog below appears. Not only can you copy an object from one database to another, but it also allows you to specify a different owner and name for that object as well.
|
All content on this site, except where noted, represents an original work of Michael R. Hotek and is protected by applicable copyright laws. The SQL Server FAQ is the sole work of Neil Pike. No page, portion of a page, or download may be used for commercial purposes in whole or in part without the express, written permission of the applicable author.
