2 Replies Latest reply on Sep 4, 2019 9:24 PM by KiwiAndrew

    19.2 SQLServer Multiple Schemas show Duplicate Columns for Table


      I am using SQLDev with the jdts-1.2.8.jar ODBC Driver.


      I have a SQL Server Database which has multiple schemata containing the same set of tables (using the schema to separate dev, test, etc).


      When I double click a table in the  Connection browser, the Column list opens and shows one entry per column, per schema.


      for example - this table appears in 7 schemas:


      and shows like this:




      The Column list isn't filtered by the Schema name, only by the Table name.


      Expected: it should only show the columns for the instance of the table in the schema on which I clicked...


      Note: If I show the data, it correctly shows the data for the table in the selected schema...