Work faster

Last modified: May 9, 2023

dbForge Search is an add-in for SQL Server Management Studio (SSMS) and that enables users to easily search for database objects and data within SQL Server databases. With this tool, you can easily search for various types of information, including object names, columns, stored procedures, views, and functions. You can filter results based on data types and null values and search for specific code snippets or queries within SQL scripts.

dbForge Search can increase productivity by quickly finding the information you need, reducing the time and effort required for database management tasks.

• Rapid object search: Swiftly locate tables, views, stored procedures, functions, and other database objects in large and complex databases.

• Match case search: Perform case-sensitive searches for text in databases.

• Search of the whole word: Search results that contain the exact word or phrase you are looking for.

• Instant text search: Speedily locate specific text or phrases in object definitions, saving time during code reviews or debugging.

• Efficient object navigation: Efficiently locate and navigate to the corresponding object in the Database Explorer tree based on the results of your object search.

SQL specialists have their own ways to seek necessary objects in databases. As usual, they use the sys.objects view to search for objects in databases. This approach is effective, but dbForge Search for SQL Server makes it possible to search based on specific criteria without delving into the details of the database schema. By the way, if you are interested in different methods for finding objects in databases, feel free to read the How to Search for Database Objects, Table Data, and Value in SQL Server article.