There are many scenarios where the tool can come in handy. For example, imagine trying to perform a modification in a table and there is a view using the “WITH SCHEMABINDING” option which binds the view to the schema of the specific table. So, in order to be able to perform the table schema modification you will first need to either modify or delete the view. So what can you do for finding any views, functions or any other objects that reference the table? You can search for such database objects referencing the table name in their definition.
Below I am presenting some screenshots illustrating the usage of the tool.
After installing SQL Search and starting SQL Server Management Studio, you will notice that there is a new add-in added:
When clicking on the SQL Search add-in you are presented with the following screen:
The following screenshot explains the main controls of the tool:
For this example, I typed the text “customer” and searched for all the database objects, in all the databases within the instance that reference it. To this end I was presented with the following screen:
When clicking on a programmability item, i.e. a stored procedure, you are also presented with a preview of its T-SQL code that among other references the database objects having the provided text fragment:
Then, by double-clicking on the item, or by clicking on the “Select object in Object Explorer” hyperlink, you are able to access the object via SSMS Object Explorer:
Another important thing is that the tool is free and you can download it from here 🙂
I hope you found this product review useful!
Check also – Our high-quality online courses:
- Boost SQL Server Database Performance with In-Memory OLTP
- Essential SQL Server Administration Tips
- SQL Server Fundamentals – SQL Database for Beginners
- Essential SQL Server Development Tips for SQL Developers
- The Philosophy and Fundamentals of Computer Programming
- .NET Programming for Beginners – Windows Forms with C#
- Introduction to Data Science and SQL Server Machine Learning
- Introduction to Azure SQL Database for Beginners
- SQL Server 2019: What’s New – New and Enhanced Features
- Entity Framework: Getting Started – Complete Beginners Guide
- How to Import and Export Data in SQL Server Databases
- Learn How to Install and Start Using SQL Server in 30 Mins
- A Guide on How to Start and Monetize a Successful Blog
Rate this article:
Reference: SQLNetHub.com (https://www.sqlnethub.com)
Artemakis Artemiou is a Senior SQL Server Architect, Author, a 9 Times Microsoft Data Platform MVP (2009-2018) and a Udemy Instructor. He has over 15 years of experience in the IT industry in various roles. Artemakis is the founder of SQLNetHub and TechHowTos.com. Artemakis is the creator of the well-known software tools Snippets Generator and DBA Security Advisor. Also, he is the author of many eBooks on SQL Server. Artemakis currently serves as the President of the Cyprus .NET User Group (CDNUG) and the International .NET Association Country Leader for Cyprus (INETA). Moreover, Artemakis teaches on Udemy, you can check his courses here.