suppose we have a column named (product_id) . This column is found in tables (product, store, supplier).. However, we knew that the column is named (product_id) but we didn't know in which tables it was.
is there a way that we write
SELECT product_id
FROM ...
and when we reach FROM it gives us a list of the tables containing such columns?
asking for a shortcut or something similar, in ((DBeaver)).
please note that using ctrl+space in the FROM clause gives us a list of all the tables even the ones that don't contain the specified column.