Search Column_Name in all tables

How to find Column_Name in all tables ?
Yes. there is multiple ways, but simple query is below.

select TABLE_NAME , column_name
from INFORMATION_SCHEMA.COLUMNS
where column_name like '%jobtitle%'

No comments:

Post a Comment