DEV Community

Cover image for Find column from all tables
Adam K Dean
Adam K Dean

Posted on

2

Find column from all tables

A very useful SQL snippet today, courtesy of Danny Dawes and SQLAuthority.

The following query will list all tables that reference a specific column name:

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;
Enter fullscreen mode Exit fullscreen mode

Just change %EmployeeID% to the column name you're looking for.

Top comments (0)

AWS Security LIVE!

Join us for AWS Security LIVE!

Discover the future of cloud security. Tune in live for trends, tips, and solutions from AWS and AWS Partners.

Learn More