News
Product features
Search tools
Object references
Bulk edit
Code history
Scripting
Testimonials
Downloads
Licences
System requirements
FAQs
Reviewer Guide
About me
Contact me
SQL Editor is an explorer / editor tool for SQL Server development.
The screenshot above shows a familiar Explorer-like interface. The database structure is shown in the tree view on the left, while details of the selected object are shown in a code pane on the right.
Looking more closely, we see that there are folders for each basic object type: stored procedures, tables, views and user functions (this last folder is only displayed for SQL Server 2000 databases).
There is also a search results folder, which shows all the database objects which contain the word "products" somewhere in their definition.
The first item in the search results is the CustOrderHist stored procedure. Because it is currently selected, the create code for this object is showing in the code pane.
The currently-selected CustOrderHist node has child nodes for the OrderDetails, Orders, Customers and Products tables. This illustrates that the stored procedure refers to these tables, as a quick look at the code will confirm.
The Orders table's node in turn has its own child nodes, illustrating that it refers to the Customers, Shippers and Employers tables. These are foreign key references.
Click below for more detailed information about:
- Search tools to find the objects you need to work with;
- Object references to view references and dependencies;
- Bulk edit to make the same change to many objects;
- Code history to review old versions;
- Scripting to generate scripts for objects.