How to find Column_Name in all tables ?
Yes. there is multiple ways, but simple query is below.
Yes. there is multiple ways, but simple query is below.
select TABLE_NAME , column_namefrom INFORMATION_SCHEMA.COLUMNSwhere column_name like '%jobtitle%'
No comments:
Post a Comment