Posts

Showing posts from March, 2011

Search All Tables in SQL Database for a Value

You can use the following query to perform your search. Just replace the "@myValue" with your value. Declare @TN as varchar(200), @CN as varchar(200), @myValue varchar(30), @SQL as nvarchar(1000) , @SN as varchar(200), @Exact_Match bit Create Table #myTable (Table_Name varchar(200), Column_Name varchar(200), Number_Of_Rows int) -- Replace @myValue with the value you're searching for in the database Set @myValue = 'Value to Search' -- 0 for LIKE match, 1 for exact match Set @Exact_Match = 1 Declare myCursor Cursor For Select T.Table_Name, C.Column_Name, T.Table_Schema From INFORMATION_SCHEMA.TABLES T Inner Join INFORMATION_SCHEMA.COLUMNS C On T.Table_Schema = C.Table_Schema And T.Table_Name = C.Table_Name Where T.Table_Name <> 'dtproperties' And Table_Type = 'Base Table' And C.Data_Type In ('varchar','char','nvarchar','nchar','sql_variant') --And C.Data_Type In ('text',&#