I am able to connect to table and see the columns using JDBC connection. How can I check the views in any schema.
Could someone please guide me through .
Sure, there are some additional options that can configured when creating a database connection. To include the views, click edit the existing database connection and click 'Show advanced options".
The window will expand and there will be an option to 'Include views'.
Click apply, and the database views will appear under the JDBC connections.
Hope that helps!
Thank you Katya. It worked
Appreciated your time and effort