SQLPRO SEARCH FOR COULMN CODE

public static void SearchDialog(this DataContextBase dc, string searchString = '%') inside a public static extension class (in LinqPad 6, it is DataContext). The data context can be passed from the query window as DataContextBase dc via parameter, i.e. Then you can write a static extension class and save it under My Extensions to be used in your LinqPad queries. Note for LinqPad users: In C#, you can use dc.ExecuteQueryDynamic(sqlQueryStr, new object ).Dump() and have the parameters as.

Note that I've verfied this script with a test view dbo.TestOrdersĪnd it found the CustomerID in this view even though c.* was used in the SELECT statement (referenced table Customers contains the CustomerIDand hence the view is showing this column). Note that you can set to 0 if you just want to display the SP names, and if you're just looking for tables/views, but not for SPs, you can set to 0.Įxample result (find CustomerID in the Northwind database, results displayed via LinqPad): If you run the query, use the 'result as text' option - then you can use 'find' to locate the search text in the result set (useful for long source code). Where column_name like by c.table_Name, c.column_name Where routine_definition like routine_type='procedure' 'PROCEDURE' as table_type from information_schema.routines Left join information_schema.Tables t on c.table_name=t.table_name

SQLPRO SEARCH FOR COULMN CODE

It displays the result in one table distinguishing 'BASE TABLE', 'VIEW' and 'PROCEDURE', and (optionally) the source code in a second table: DECLARE nvarchar(max)='%CustomerID%' - search for this stringĭECLARE bit = 1 - 1=search in SPs as wellĭECLARE bit = 1 - 1=display SP source code The script below first lists the tables/views containing the column name you're searching for, and then the stored procedures source code where the column is found. I developed such a script some time ago because I needed to search for field names everywhere in the database. You can use the system views contained in information_schema to search in tables, views and (unencrypted) stored procedures with one script.

Sqlpro search for coulmn