Missing View column names in generated DDL code

Answered

I'm using 'Database' tab in IntelliJ but I've seen same issue in DataGrip as well. Here is what I'm doing in Oracle:

create view ABC (AAA) as select ID from SOMETABLE;

If I go to 'Database' tab, there is a new view called ABC with column AAA, as expected but when I open DDL source code editor Ctrl+B it says

CREATE VIEW ABC as select ID from SOMETABLE;

First obvious issue is that "replace" word is missing, but there is a workaround with "Code Generator" discussed here... And the most important complain here is that column name (AAA) is missing, that I can't bring back even with Code Generator.

Am I missing some checkbox somewhere?

------------------

Just guessing: probably editor query from USER_VIEWS instead of dbms_metadata.get_ddl(...)? I see 'AAA' in USER_TAB_COLUMNS.

1
2 comments
Avatar
Yaroslav Bedrov

Hello,

We have related issue on YouTrack: https://youtrack.jetbrains.com/issue/DBE-6261

Please follow it for updates.

 

1
Avatar
Permanently deleted user

So the issue you referencing is now fixed and now I can "Request and copy original DDL", that will contain the "replace" word and column names.

The other two options "generate DDL to console/clipboard" have their original behavior that is nice too.

Thank you!

0

Please sign in to leave a comment.