Search for (part of) a table column name in an SQL Server Database using Dbeaver UI search function
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.
It seems that DBeaver does not have this feature. See the comment by TheMechanist902, Apr. 16, 2024 on DBeaver Github Issue "Add column name object in the metadata search for Oracle databases" (#8684).
I recently noticed this feature is not available for MSSQL either. However I found a workaround that is independent from the used DBMS.
By displaying the ERD diagram you can search the diagram for any string. This includes columns names. It's a bit clunky, but better than nothing.
Of course this isn't a real replacement for a proper search feature, but maybe it helps in a pinch. Theoretically you can search inside an exported graphml file as well.
- Unrecognized column name that I define
- How to merge 2 or more rows and SUM a column in an UPDATE without a primary key?
- What are the advantages of running SQL Server in a Docker container?
- How do I get the MAX of two values in SQL Server?
- How can I split a single, very long string into separate columns and rows delimited by commas and semicolons in SQL Server?
- Why can't I use table names of aliased tables in WHERE clause?
- Function vs. Stored Procedure in SQL Server
- How to correctly join two tables that each have Start Date and Stop Date columns?
- How to run sql script using SQL Server Management Studio?
- SQL copying data with new foreign keys
- SQL Server truncates decimal points of a newly created field in a view
- SQL Grouping and Nested Concatenation
- How to pull width & height out of string?
- The locale identifier (LCID) 8192 is not supported by SQL Server
- SQL Server Initial database connection timeout in 30 seconds
- Why use a READ UNCOMMITTED isolation level?
- Recursive CTE and how to overcome circular reference error
- Select min or max based on where duplicate value exists
- Converting accented characters in varchar() to XML causing "illegal XML character"
- Incorrect syntax near '1'. Expecting ID, QUOTED_ID, or '.' Error with SQL Pivot
- Update SQL table using selection from another table
- Clarification on joins
- Foreign key constraint may cause cycles or multiple cascade paths?
- pyodbc cursor.fetchall() is returning "strange" values
- T-SQL Get File Extension Name from a Column
- How to do a cross-database-query join in SQLAlchemy?
- Return the contents of an EXEC from a stored procedure
- How to transform "Types" a List<string> foo class property into a SQL Server table [Types](FooID int, name nvarchar) with Entity Framework Core
- List the queries running on SQL Server
- Recordset Closed After Stored Procedure Execution