Find column in the whole database in sql server

To find a specific column in the whole database in SQL Server, you can query the information schema views. Here's a query you can use: SELECT table_name, c…

Author

SQLDataDev Editorial Team

Mar 19, 2026 1 min read

To find a specific column in the whole database in SQL Server, you can query the information schema views. Here's a query you can use:

SELECT table_name, column_name,*
FROM information_schema.columns
WHERE column_name LIKE '%Col name%' 
AND TABLE_CATALOG = 'DatabaseName'

Topics covered

Keep building your data skillset

Explore more SQL, Python, analytics, and engineering tutorials.

Browse All Posts