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.
Please sign in to leave a comment.
Hello,
We have related issue on YouTrack: https://youtrack.jetbrains.com/issue/DBE-6261
Please follow it for updates.
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!