Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

19.2 SQLServer Multiple Schemas show Duplicate Columns for Table

KiwiAndrewSep 4 2019 — edited Sep 4 2019

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:

pastedImage_0.png

and shows like this:

pastedImage_2.png

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

Comments
Post Details
Added on Sep 4 2019
2 comments
152 views