I made this application to make it easier to search a Microsoft SQL Server database. The application makes it possible to search in:
- Table names
- Table column names
- View names
- View column names
- Index names
- Stored procedure names
- Stored procedure definitions
- Stored procedure parameter names
- Function names
- Function definitions
- Function parameter names
The application searches the specified database system views for the information.
When right-clicking a found stored procedure name og function name in the treeview, its possible to get the definition shown.
- Alt-C: Connect
- F3 or Alt-F: Find
- F12: Show definition of stored procedure og function
- Make it possible to use more than one search term
- Implement the 'Match case' checkbox functionality
- Display metadata about the found element when clicking the TreeView node
- Display metadata about the connected server
- Right-click in treeview to find all references
- Right-click in treeview to show content of stored procedure or function
- When matches are found in the definition of stored procedures and functions, then highlight the matches
The login dialog
Search
View definition
Icons for the application is from: https://github.com/ioBroker/ioBroker.icons-open-icon-library-png