KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I have this query that finds all tables and views that matches my column name of a certain database. I am using SQL SERVER 2008 SELECT table_name FROM information_schema.columns WHERE column_name = 'product_name' I want to extend the capability of my query to search across all databases and even look for Stored procedures whose having my searched column name.
Tags (comma-separated)
Save Edits
Cancel