Dec 8, 2019 · I need to search an SQL Server database for all mentions of a specific string. For example, I would like to search all tables, views, functions, stored procedures, ... for string "tblEmployes" (not data within the tables).

May 31, 2023 · You have to first enable Full Text Search on the table before using contains keyword. For more details, see Get Started with Full-Text Search.

Feb 5, 2013 · The first parameter @search is the search criterion, @target the search target, i.e., procedures, tables, etc. If not specified, search all. @db is to specify the database to search, default to your current database.

Jun 29, 2020 · In this article, we explored various ways to search for SQL database objects in SQL Server. We can use T-SQL, object explorer search, SSMS filter, as well as third-party tools such as ApexSQL Search for the same. You can choose the …

Mar 26, 2025 · In this tutorial, we explored different options to filter rows that contain specific words or phrases. Combined with wildcards, the LIKE operator offers a powerful and flexible approach to pattern matching and is available in all SQL implementations. Pattern-matching operators available in each database enable advanced search operations.

Jul 22, 2021 · stringToFind – this is the search string you are looking for. This could be a simple value as ‘test’ or you can also use the % wildcard such as ‘%test%’, ‘%test’ or ‘test%’. schema – this is the schema owner of the object.

Mar 9, 2016 · The need to search through database schema for specific words or phrases is commonplace for any DBA. The ability to do so quickly, accurately, and completely is critical when developing new features, modifying existing code, or cleaning up the vestiges from an application’s ancient history.

Feb 13, 2009 · SQL Search has the ability to search for object names, or text strings within objects, directly from SSMS. The best way to learn what it can do is to show you, so let’s get started.

ApexSQL Search is a SQL search add-in for SSMS and Visual Studio. It can search for text within database objects (including object names), data stored in tables and views (even encrypted ones) and repeat previous searches in a single click.

Feb 22, 2010 · You could create a full text index across all 3 search-able columns which would also give you the ability to query a specific one (or combination) if the need arose - e.g. you want rows where the search text exists in the [Description] only.