Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.

4 Answers
4

You can use following query to list all columns or search columns across tables in a database.

USE AdventureWorks
GO
SELECT t.name AS table_name,
SCHEMA_NAME(schema_id) AS schema_name,
c.name AS column_name
FROM sys.tables AS t
INNER JOIN sys.columns c ON t.OBJECT_ID = c.OBJECT_ID
WHERE c.name LIKE '%EmployeeID%'
ORDER BY schema_name, table_name;

You can make use of information_schema views to list all objects in SQL Server 2005 or 2008 databases.

SQL Search is a good tool, but keep in mind that the results window is arbitrarily limited to, I believe, 250 results. The last time I used this tool, Red Gate did not have a way of lifting this limitation. That having been said, it is still a very useful tool and I would recommend it to any SQL Server DBA or Developer. The price is right too!
– Matt MJan 11 '11 at 14:06

Thank you for your interest in this question.
Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).