Skip to content
Advertisement

Get a list of database tables that contain a specific column field?

How to select all tables that contain a specific column?

Advertisement

Answer

Is this what you expect?

demo: db<>fiddle

SELECT table_name
FROM information_schema.columns
WHERE column_name = 'your_column_name'
User contributions licensed under: CC BY-SA
6 People found this is helpful
Advertisement