Suppose I have a database My_DB
with hundreds of tables.
Now, I need to find about a particular column My_Emp_ID
in my database.
I tried manually searching each table, but it is not efficient.
What is the best way to find all the tables that contain column My_Emp_ID
?
You can assume that schema
is same for all the tables present in the database.
Thanks.
select *
from INFORMATION_SCHEMA.COLUMNS
where COLUMN_NAME = 'My_Emp_ID'