Hi,
we have a development environment with a number of users sharing a set of tables owned by a common user. I'm logged in using my database user and I'm trying to add a few tables to the shared schema and define PK and FK constraints between them but the functionality seems to be broken in sqldeveloper 17.2.
Steps to recreate:
1. Using the navigation to find the table, right click on the table and bring up the edit wizard and click on the constraints section. No constraints are shown. It's possible to add a PK using this section but it won't then show when you re-enter the wizard. You can't add FK as the wizard can't see the PK on any other table.
2. Using the navigator to find the table right click and use the Quick DDL to export to a Worksheet. Only the PK is shown, no FK are visible.
3. Looking at the table in the table details pane, the constraints are correctly shown and the SQL tab shows the sql needed to create them correctly
4. Database exports of DDL from sqldeveloper show the constraints correctly.
Does anyone else see this same issue?
Thanks,
Russell