Start a new topic

SQL Server Views Columns

[This topic is migrated from our old forums. The original author name has been removed]
[Attachment has been removed.]

I have a connection to SQL Server 2012 using Microsoft JDBC 4.1 driver. In the Databases tab under that servers tree I can drill into Tables and then drill into Columns to see list of columns on the table. When I try to do the same for Views, I only see Triggers as a drill down option in the tree. What do I need to do to be able to see the Column list in that tree view? I have attached screen shots of what I am referring to.

[This reply is migrated from our old forums.]

Re: SQL Server Views Columns
Hi Eric, There is currently no way to see the columns for a SQL Server view as nodes in the tree, but we will add this in the next maintenance release. Best Regards, Hans
[This reply is migrated from our old forums.]

Re: SQL Server Views Columns
Eric, This is now fixed in the just released 9.2.9 version. http://www.dbvis.com/download/ Regards Roger