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

    19.2 SQLServer Multiple Schemas show Duplicate Columns for Table

    KiwiAndrew

      I am using SQLDev 19.2.0.206 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:

       

      etc...

       

      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...