Skip to Main Content

SQL Developer for VS Code

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!

Table describe behavior appears limited for wide tables (greater than 100 columns)

Gary G.Aug 8 2024

It seems like there isn't a way to see all columns in a table when viewing the table details in SQL Developer for VS Code. A developer on my team noticed this behavior and I am able to replicate it, even in the latest 24.2.0 release.

When describing tables (click the table name in the schema pane, a new tab opens with the column list and details), only the first 100 columns are shown. However, if I expand the table node in the schema pane, all columns are shown. I can't seem to find a “more” button or even indication that the output is limited and incomplete. If there is a user-accessible setting to control this, I haven't found it.

Is there some way I can control this behavior and see all columns when a table has more than 100?

The log output is attached where the “limit”:100 key/value pair is clear in the response.

sqldev-vscode-24_2-table-describe-has-100-col-limit.txt

This shows the issue visually (broken up for readability, showing the top-n and bottom-n).

This shows the table node expanded, where all columns are shown.

This post has been answered by thatJeffSmith-Oracle on Aug 8 2024
Jump to Answer
Comments
Post Details
Added on Aug 8 2024
1 comment
80 views