Searching all tables in database containing specific column

Question

I am looking for a simple query to find all tables within a database that have a certain "id" column, confusing myself as not all the tables contain this "id"

user_5070879 · Answer

Using INFORMATION_SCHEMA.COLUMNS:

SELECT *
FROM INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME = 'id'

Searching all tables in database containing specific column

1 Answers