I need to look into a SQL Server database and find a column for BI purposes.
I found the DBeaver Metadata search function (Ctrl+H), and on a PostGreSQL server I can see “Table Column” as a possible object to search.
However, the database I need to search is SQL Server, and there is no “Table Column” object there to search in. If I want to search the whole database for columns that contain for instance “%suppress%” in the column name, how do I go about it? Specifically using UI, not a SQL statement.
I tried using the DBeaver Metadata search and expected to have an object “Table Column” there. In reality, there is no Table Column object. The search for “%Suppress%” yielded no results although there are at least to table columns that have “suppress” in their name.
Bart Van A is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
7