Recently, I am immigrating some data from Postgresql to a MSSQL2012 server. In SQLWorkbench, I can see comments on tables and columns in SQLServer.
But in DBeaver
, I can't see any comment or remarks on any object. The Description column in Properties tab are always empty.
Is this a configuration issue, or is DBeaver just not ready for this ?
Both SQLWorkbench and DBeaver are using MS' JDBC driver.
Best Answer
The Microsoft JDBC driver does not return that information through the standard JDBC API. I think the main reason for that is, that the driver uses
sp_columns
internally (at least the last time I checked - which is a couple of years back) and that procedure doesn't return that information.I guess DBeaver simply has no special code to retrieve the "extended properties" for tables or columns for SQL Server, whereas SQL Workbench/J "knows" those extended properties