Published on: 29 Sep, 2019

How to find all tables in database contain specified column name in SQL Server?

Tumblr Digg Google Plus

If you want to find a list of tables column contains the specific name in SQL server, you can easily using the following query. This query will be handy especially if you need to dig or trace where exactly the column come from.

SELECT * FROM INFORMATION_SCHEMA.COLUMNS 
WHERE COLUMN_NAME LIKE '%ColumnName%' 
ORDER by TABLE_NAME

Comments

There are no comments available.

Write Comment
0 characters entered. Maximum characters allowed are 1000 characters.