Find Columns Name in the MSSQL DataBase

Hello Fellas,

Today I'm sharing the learning to how to find the column whose table name is unknown to us.

here is the query,


select * from INFORMATION_SCHEMA.COLUMNS where COLUMN_NAME like '%TurnAroundTime%' order by TABLE_NAME

Thank You :)