spSearchTables: Search and Find Tables or Columns by Name or Value

Federico Di Marco

Rate me:

5.00/5 (4 votes)

21 Nov 2023CPOL6 min read

7.4K

spSearchTables: a helper T-SQL stored procedure for digging into (large) databases

spSearchTables is a helper stored procedure which allows you to search tables or columns either by name or by value in all databases in a server using SQL pattern matching.

Views

Daily Counts

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Written By

Federico Di Marco

Software Developer (Senior)

Italy

I'm a senior .NET software engineer in the second half of my forties. Started using a computer at six years, gone through logo, basic, assembly, C/C++, java and finally to .NET and .NET core. Proficient also in databases, especially Sql Server and reporting. Let's say I have also some experience on security but mainly in the past, now things have become much more difficult and I do not have too much time to keep me updated, but sometimes I am still kicking in. Fan of videogames, technologies, motorbikes, travelling and comedy.

Email: Federico Di Marco <fededim@gmail.com>
Linkedin: LinkedIn
Github: GitHub
Stackoverflow: StackOverflow

spSearchTables: Search and Find Tables or Columns by Name or Value

Views

License

Comments and Discussions