Nearly 7,000,000 Oracle professionals use SQL Developer on a regular basis. Have a question about Oracle SQL Developer? Searched this blog and couldn’t find the answer? Ask away!
If your question is about Oracle Database, SQL, PL/SQL, etc – go Ask Tom!
Feel free to ask anything you want, but I’ll feel free to send you to Support or our Forums if it goes sideways.
Note: This page has turned out way more successful(?) than I would have ever imagined. Please keep these things in mind when asking questions.
- I am NOT support. Don’t expect me to log bugs for you, or give you official timelines on bug fixes, enhancements, or product releases.
- I AM NOT SUPPORT. Don’t open an SR with My Oracle Support AND leave a question here. Pick one and go with it, and when in doubt, go to My Oracle Support.
- I try to answer questions as quickly as possible. If you don’t get an answer, ask me for an update. I may have just forgotten or overlooked your request.
Go!
7,827 Comments
sql developer version 4.0.2.15
I have a connection defined that is now, all of a sudden, receiving the below error when trying to connect. SQL history shows that I last used this connection 7 days ago, with no errors. All my other connections are working correctly. Famous last words, but nothing has changed on my pc. Same connection info (tnsnames.ora) works in Toad.
oracle.jdbc.driver.T2CConnection.getLibraryVersionNumber()
Vendor code 0
An error was encount
What version is the database, what version of the JDK is SQL Developer using, what version of the Oracle client do you have installed?
Hi Jeff,
I am trying to solve a puzzle now for a couple of days of how to draw data from a MySQL-database with SQL Developer into an Oracle-database without having to migrate the whole MySQL-database to Oracle. I know that I could use the ‘Copy to Oracle’ function to only copy some selected tables to Oracle, however the tables I then need to copy are quite large, containing more than 10 years of information which will take too much time to copy each month.
– Is it possible to translate the ‘Copy to Oracle’ function into a (PL/) SQL query, so that I can further specify which data I would like to copy from MySQL to Oracle?
– Is it maybe possible to write something like this?:
create view data_from_mysql
as
select
*
from .@
where .date >= to_date(’01-01-2014′, ‘dd-mm-yyyy’)
;
– So, is it possible to select data in a MySQL-database and schema from within an Oracle-database and schema, and, if yes, how?
I hope you can help me solve this puzzle or point me into the right direction. Your advice will be very much appreciated!!
Thanks and regards,
Klaas
I would do one of the following:
I would go the 2nd route.
The copy to Oracle method won’t grab indexes, keys, constraints – all that ‘fancy’ database stuff.
Hi Jeff,
Thanks again for your advice, I will go for the second route then :).
Kind regards.
Hi Jeff, I appreciate your willingness to address questions! I’m having an interesting issue. Let’s say I’m signed into oracle instance: test. In a sql window I type emp, put my cursor over it and press shift+f4. I am then prompted to sign into database: prod. Any idea what’s causing this?
Thanks in advance!
Do you have a file open in this worksheet?
Hi Jeff,
I have been checking on the various website on how to setup the SQL loader to load the data into Oracle tables but none were most usefull, most of them only discussed about how to build a control file, load the data into Oracle tables but I have not seen any usefull stuff describing what needs to be done the background for that loading to happen.
I mean what tools are required i.e. UNIX (PuTTy etc), SQL Plus, SQL Loader, user creation , profile creation, environment setup etc. and who is responsible for each task.
Could you please give me a detailed background of it as I have never worked on SQL Loader, now I got an opportunity to work on SQL loader to load the data into oracle tables. So it would be really great if you can explain me how to install the tools I need, what user access level should I have and do the initial development environmental setup for me to start using SQL Loader.
Your help will be greatly appreciated,
Thanks and Regards,
Raj.
The only tools you need to use SQL*Loader are:
SQL Developer just makes it easier by letting you look at the data, and marshall it into the control and data files that you can go straight to SQL*Loader with.
When I use Find Database Object, a worksheet tab is always opened for the connection I have selected (DBTEST). The tab for the search target is also opened. Why is a Connection tab always opened? I just click on it to close it, since I never really use it.
was DBTEST already connected? If not, when you select it, that opens that connection, and by default we open a worksheet on connect.
So go into preferences and disable, ‘Open a Worksheet on connect’
Jeff,
I have a data model, if i change few attributes and add and delete few objects in an existing data model,
how can i generate a DDL only for this changes rather than the entire data model ?
Thanks.
You probably want to do a compare of your existing model to the previous version. Then you can generate an ALTER script that just has the changes between the two versions.
Hi again Jeff,
More questions. I’m pretty sure SQL Developer wants you to store your package spec and body in separate files. Is that correct? In TOAD, the file splitting was handled automatically. Not a big issue, I’m just confirming if this is the case.
Also, can you please explain what the preference setting “Supported Sync Spec and Body” does? I can’t find anything about it in the reference material or by searching the web.
In my Oracle SQL Developer, 4.0.1.14, I used to be able to issue this command in the worksheet ” ‘set worksheetname ‘ ” and the tab would be named “WorksheetName” from then on. A few weeks ago that functionality just stopped. Now I issue the command, the tab names does not change and that’s it.
I’m sure I have changed some setting that has had this effect. Can you enlighten me?
Weird. There’s no option – sounds more like a bad internal config or session file. You could try the Windows > Reset Factory default to see if that helps, but I doubt it will.
You could try to upgrade to 4.0.2 – but that’s not a known bug, so there’s no explicit fix.
My OS is Windows 8.1 and I am using SQL Developer 4.0.2.
Currently I have two questions:
I cannot use SYS as sysdba to login my local database, I always got ORA-01017 error.
But I can use sql*plus or PL/SQL Developer or Toad for oracle to log it into the local database.
In addition, I am interested on Unit Test feature.
However, when I use repos_owner to login the local database, the Tools ➤ Unit Test ➤ Select Current Repository is gray out.
Would you mind helping me to solve these issues?
Thanks you very much!
Best regards,
Edwin
>>I cannot use SYS as sysdba to login my local database, I always got ORA-01017 error.
Those other tools are installed on the same computer as SQL Developer? What happens if you try to connect with SQL*Plus from the same machine?
I can use sql*plus or PL/SQL Developer or Toad for oracle to log SYS as sysdba into the local database without any problem.
Thanks!
Are you using Direct or TNS to define the connection? My last/best guess is that you’re not connecting to the database you think you are – and of course you’re using the dropdown to change the connection type to AS SYSDBA, of course.
Thank you very much for your advice! I finally log SYS as sysdba into the local database via SQL Developer without any problem.
In addition, would you mind telling me where I can find more details and examples about how to use SQL Developer to do Unit Testing? Thanks!
I would start with our hands on lab.
I have setup sqldeveloper on a windows 7 64bit computer and it lets me connect but we use multiple users on the same computer and I cannot run the program when logged in as a different user. What must I do so all the users can use the initial installation of sqldeveloper?
What happens when they try to use it? We’re setup to support multiple OS users per machine – each user gets their own set of user preferences in their $USER$/Application Data directory.
When I log on as user1 sqldeveloper opens correctly. When I log on as user2 and try to open sqldeveloper I get the following:
(1) A command prompt box with the following:
Warning: Could not find jvm.cfg! in ‘C:\Program Files\JAVA\jdk1.7.0_45\jre\lib\jvm.cfg
Warning: Cannot find default VM “client” at C:\Program Files\JAVA\jdk1.7.0_45
ERROR: cannot find vm at c:\Program Files\JAVA\jdk1.7.0_45
Aborting!
(2) I then get a Oracle SQL Developer box on the screen with the following:
Unable to find a Java Virtual Machine to point to a lcation of a JAVA Virtual Machine, please refer to the ORACLE9i Developer Install Guide (jdev\install.html)
This did not help me find the solution.
So SQL Developer is setup to be allowed for multiple users, but maybe the JDK isn’t.
What are the procedures to setup jdk for multiple users?
If you’re on versions 1-3, you configure that in the sqldeveloper.conf file in the bin directory and that will affect ALL users of that install.
If you’re on versions 4 and higher, you configure it in the product.conf file for each user in their OS user directory.
Sorry for the the delay in getting back but I checked and it looks like your response is related to a linux based system not Windows based. I am using sqldeveloper on a Windows 7 machine and cannot fine the product.conf file to edit? Am I missing something about this? Sorry but I am a newbie to sqldeveloper.
If you’re on Windows, then it’s in your Application Data directory. That is sometimes hidden in Windows.
Thanks for all your help. I finally determined the problem to be the location of the install for Developer. Once I pointed to the correct location I was able to open Developer without problems. I do not know why but it did not install the normal location but this was probably due to me being a Newbie with this product. Thanks for all your help
Is there a way to setup SQL Developer so one can run a pre-existing query only?
We (IT) would create the query, but the end-user could only run it without modifying it or access to any other ability to create other queries?
Thanks
Hmmm. No.
What I would recommmend. Create some VIEWS – those would be these end-user queries. And then create an APEX application that paints web pages for those views/reports. Your end users would have APEX logins, but not database logins. How does that sound?
BTW, APEX is free, and is very little work to setup and create a page.
Hi Jeff,
I tried to run the unit testing from Unix command prompt through sdcli command, but it get hanged for ever. I am using version 4.0.2. Is it possible to call unit testing module of Oracle SQL developer from Unix enviroment?
Below is the out put when I tried to run the sdcli command with bash -x command.
++ . sdcli unittest -run -suite -name DEMO -repo testdb -db testdb
+++ . sqldeveloper
++++ /opt/sqldeveloper/sqldeveloper.sh
Please help me.
Hi.
How can I export my custom rules and data model together?
Hi Jeff;
I have one project on hand, I need your advice, we will migrate from
one erp software to other Erp. (the old erp runs on SQL server 2008 and the new erp will run on oracle with Linux).
My work plan is compare functionality of two systems, compare data and also reports, after align data migrate from old to the new. without
forgot store procedure and triggers (for reports).
I need your advice, my work plan is on the right way or no ? what migration tool you will suggest to me.
Thanks in advance for the help.
Roger Lam
I would advise you engage the ERP solution team here at Oracle directly. For example they have a specific tool/strategy for moving PeopleSoft from SQL Server to Oracle.
But in general, I’m guessing that there are lot of people that have built things on top of your system that won’t know about until you turn it off and do the switch over. Try to identify those reports, tools, dashboards, etc. ahead of time.
I copy SQL Developer’s Standard Report/Database Administration/ Sessions – Session report, copy it into my User Defined Report leaf.
I can run the report, right click and KILL SESSION.
If however, I edit the SQL to add in LOGON_TIME. The report runs OK, but I lose the KILL SESSION option.
Can I resolve this problem?
Did you edit the report to add the Kill Session action in the first place?
No, I copied the SESSION report from the Data Dictionary Reports, but I then worked out that I had to edit the USERREPORTS.XML to modify the report to do what I required.
Thanks.
Alex.
Something you did in the XML made the report..’not happy.’ I can’t debug your report, but I would open it and look for tags not closed, typos, etc.
Unable to start SQL Developer on Windows 7. It worked perfectly on my older laptop but refuses to start. No errors or splash screen.
I run the program using:
C:\sqldeveloper\sqldeveloper\bin>sqldeveloper.exe -verbose
Processing Hotspot specific options
Processing Hotspot JDK 7 specific options
savedArg0 = C:\sqldeveloper\sqldeveloper\bin\sqldeveloper64.exe
VM to launch C:\Program Files\Java\jdk1.7.0_67\jre\bin\server\jvm.dll
JNI Option: -Xbootclasspath/a:C:\Program Files\Java\jdk1.7.0_67\lib\tools.jar;C:\Program Files\Java\jdk1.7.0_67\lib\dt.jar
JNI Option: -Dsun.java2d.noddraw=true
JNI Option: -Dnetbeans.home=/sqldeveloper/netbeans/platform/
JNI Option: -Dnetbeans.logger.console=true
JNI Option: -Dexcluded.modules=org.eclipse.osgi
JNI Option: -Dide.cluster.dirs=/sqldeveloper/netbeans/fcpbridge/:/sqldeveloper/netbeans/ide/:/sqldeveloper/netbeans/../
JNI Option: -Xverify:none
JNI Option: -Doracle.ide.extension.HooksProcessingMode=LAZY
JNI Option: -Dorg.eclipse.equinox.simpleconfigurator.configUrl=file:bundles.info
JNI Option: -Dosgi.bundles=file:/sqldeveloper/ide/ide/lib/oracle.ide.osgi.jar@3:start
JNI Option: -Dosgi.bundles.defaultStartLevel=1
JNI Option: -Dosgi.configuration.cascaded=false
JNI Option: -Dosgi.noShutdown=true
JNI Option: -Dorg.osgi.framework.bootdelegation=*
JNI Option: -Dosgi.parentClassloader=app
JNI Option: -Dosgi.locking=none
JNI Option: -Xbootclasspath/p:/sqldeveloper/rdbms/jlib/ojdi.jar
JNI Option: -Dosgi.classloader.type=parallel
JNI Option: -Dosgi.bundlefile.limit=500
JNI Option: -Dide.feedback-server=ide.us.oracle.com
JNI Option: -Djavax.xml.transform.TransformerFactory=oracle.ide.xml.switchable.SwitchableTransformerFactory
JNI Option: -Djavax.xml.stream.XMLInputFactory=com.ctc.wstx.stax.WstxInputFactory
JNI Option: -Djavax.xml.stream.util.XMLEventAllocator=oracle.ideimpl.xml.stream.XMLEventAllocatorImpl
JNI Option: -Doracle.ide.reportEDTViolations=bug
JNI Option: -Doracle.ide.reportEDTViolations.exceptionsfile=/sqldeveloper/ide/bin/swing-thread-violations.conf
JNI Option: -Xms128M
JNI Option: -Xmx800M
JNI Option: -Dide.update.usage.servers=http://www.oracle.com/webfolder/technetwork/sqldeveloper/usage.xml
JNI Option: -Doracle.ide.util.AddinPolicyUtils.OVERRIDE_FLAG=true
JNI Option: -Dsun.java2d.ddoffscreen=false
JNI Option: -Dwindows.shell.font.languages=
JNI Option: -XX:MaxPermSize=256M
JNI Option: -Doracle.ide.startup.features=sqldeveloper
JNI Option: -Doracle.ide.osgi.boot.api.OJStartupHook=oracle.dbtools.raptor.startup.HomeSupport
JNI Option: -Doracle.jdbc.mapDateToTimestamp=false
JNI Option: -Doracle.jdbc.autoCommitSpecCompliant=false
JNI Option: -Doracle.jdbc.useFetchSizeWithLongColumn=true
JNI Option: -Dsun.locale.formatasdefault=true
JNI Option: -Dorg.netbeans.CLIHandler.server=false
JNI Option: -Dide.AssertTracingDisabled=true
JNI Option: -Doracle.ide.util.AddinPolicyUtils.OVERRIDE_FLAG=true
JNI Option: -Djava.util.logging.config.file=logging.conf
JNI Option: -Dsqldev.debug=false
JNI Option: -Dide.startingArg0=C:\sqldeveloper\sqldeveloper\bin\sqldeveloper64.exe
JNI Option: -Dide.startingArg1=-verbose
JNI Option: -Dide.launcherProcessId=7680
JNI Option: -Dide.config_pathname=C:\sqldeveloper\sqldeveloper\bin\sqldeveloper.conf
JNI Option: -Dide.startingcwd=C:\sqldeveloper\sqldeveloper\bin
JNI Option: -Duser.conf=C:\Users\a343926\AppData\Roaming\sqldeveloper\1.0.0.0.0\product.conf
JNI Option: -Dtool.user.conf=C:\Users\a343926\AppData\Roaming\sqldeveloper\1.0.0.0.0\sqldeveloper.conf
JNI Option: -Dide.shell.enableFileTypeAssociation=C:\sqldeveloper\sqldeveloper\bin\sqldeveloper64.exe
JNI Option: -Dide.pref.dir.base=C:\Users\a343926\AppData\Roaming
JNI Option: -Dide.work.dir.base=C:\Users\a343926\Documents
JNI Option: -Dsun.java.command=oracle.ide.osgi.boot.OracleIdeLauncher
JNI Option: -Djava.class.path=C:\sqldeveloper\ide\lib\ide-boot.jar;C:\sqldeveloper\netbeans\platform\lib\boot.jar;C:\sqldeveloper\netbeans\platform\lib\org-openide-util.jar;C:\sqldeveloper\netbeans\platform\lib\org-openide-util-lookup.jar;C:\sqldeveloper\netbeans\platform\lib\org-openide-modules.jar;C:\sqldeveloper\ide\lib\fcpboot.jar;C:\sqldeveloper\ide\lib\xml-factory.jar;C:\sqldeveloper\ide\lib\woodstox-core-asl-4.2.0.jar;C:\sqldeveloper\ide\lib\stax2-api-3.1.1.jar;C:\sqldeveloper\sqldeveloper\lib\oracle.sqldeveloper.homesupport.jar
JVM path is C:\Program Files\Java\jdk1.7.0_67\jre\bin\server\jvm.dll
Processing Hotspot specific options
Processing Hotspot JDK 7 specific options
savedArg0 = C:\sqldeveloper\sqldeveloper\bin\sqldeveloper.exe
VM to launch C:\Program Files\Java\jdk1.7.0_67\jre\bin\server\jvm.dll
Restarting the launcher with the 64bit version
Reading exe header from jvm.dll, Machine=8664
Jvm is 64bit
Checking toplevel for C:\sqldeveloper\sqldeveloper\bin\..\..\ide\bin\launcher.dll = 0
About to relaunch with command line: C:\sqldeveloper\sqldeveloper\bin\sqldeveloper64.exe -verbose
Try the sqldeveloper64.exe in the bin directory instead – assuming your JDK is also 64 bit, and don’t run it with the verbose flag. What do you see?
Hey Jeff
After working with SQL Management Studio for 2 years, we recently installed our first ORACLE server and the DB uses sqldeveloper. I am wondering if it is possible to connect and execute commands using SQL Management Studio on an oracle DB since I just cannot get used to sqldeveloper.
SQL Developer can connect to SQL Server but SSMS won’t work against Oracle.
I don’t think anyone expects you to get used to Oracle or SQL Developer after a short amount of time, especially after years of working with MSFT stuff.
You have to give it some time.
What SSMS features do you miss most in SQL Developer?
Hello Jeff,
I’ve searched some of the introductory files of SQL Developer to get a legend of the various table icons under the Table node, but haven’t found it. Do you have a link to such a legend? Thanks in advance,
Y. Ebo
No. We have different icons for partitioned tables, IOTs, temp tables…and something else. If you look at the details panel for the object in question, that might help you out.
Hello Jeff,
you made the effort to create the different table icons for the tree to display the table type, so that it is _not_ necessary to open the details or do something else to determine this type. What else could be the purpose of the icons, other than a decorative color spot?
So without a legend the icons do not help, I’m afraid.
On the other hand, if you need a legend, they’re not very good icons. And once you learn them, you learn them.
Hello Jeff,
thanks for the answer, but imho a GUI should support the user, it’s not a tutorial. How can I know which attribute determines the icon’s shape and where to look at these attributes?
Totally agree. The GUI should support the user, hence the different icons denoting different types of tables, different compilation states of stored procedures, etc.
This is a standing request, I’ll add your vote to the list.
Hello Jeff!
I am currently migrating our MS SQL Server 2000 to Oracle 11g using SQL Developer. I encountered a problem in the association of migration repository using SQL Developer Version 4.0.2.15 Build 15.21, after trying to grant privileges and extend tablespaces, I still encountered the problem. I managed to successfully associate the migration repository by using a lower version of the SQL Developer (Version 3.2.20.09 Build MAIN-09.87).
Full details of this inquiry in here:
https://community.oracle.com/thread/3597180?sr=inbox&customTheme=otn
Up until now, I still don’t know what went wrong with SQL Developer Version 4.0.2.15. Still no answer in the Oracle thread. I hope you could shed some light on this.
Thanks!
Lynn
My first guess is that the connection/user you tried to associate the migration repository didn’t have a high enough privilege level to create the repository successfully. You need ‘DBA’ level privs.
Hi Jeff! I thought so too at first, but I used the same user/connection (same privileges) with SQL Developer Version 3.2.20.09 and it successfully associated the migration repo. Although, I have yet to try the DBA privs with Version 4.0.2.15. But I am thinking, that if the user worked with the lower version, it will also work with the later version. Or is DBA privilege is really needed for Version 4.0.2.15? Thanks!
The privs required between those two versions likely changed. Do you have the ability to create a materialized view?
I tried creating materialized view using Version 3.2.20.09, and I got the “insufficient privilege” error. I haven’t tried creating a materialized view in Version 4.0.2.15 since I am already using the lower version for the migration, but I think it will also prompt an error since the grants for the user do not include the creation of materialized view:
GRANT CONNECT, RESOURCE, CREATE SESSION, CREATE VIEW TO MWREP;
These privileges are those indicated in Oracle tutorial here: http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/sqldev/r30/SQLServerMigration/SQLServerMigration.htm?cid=5211&ssid=116482441802427
Does that mean that in the latest versions of SQL Developer, there are changes in the migration process/scripts/codes (i.e. new process creates materialized views) that require new privileges?
If that’s the case, maybe we can suggest updating the (Oracle) tutorials online for the benefit of those new to Oracle and SQL Developer.
We recommend a SYS/SYSTEM level user with DBA privs to create the migration repository.
Hello Jeff,
I’m using SQL Developer 4.0.* on both Windows and Linux. My Linux machine is the main dev machine and I have invested quite a bit of time in ‘customizing’ the UI layout (incl. keyboard shortcuts). It’s quite a drag to do the same thing with my Windows computers. Is there a way to export UI settings (not necessarily the DB connections) in an OS-independent way?
If not, that would be a great feature in a future release of SQL Developer…
Everything is pretty much OS independent. You could try copying your $HOME/.sqldeveloper/ folder where your 4.0 settings are to your Windows Application Data/Roaming Profiles/SQL Dev directory and have it pretty much come over. If you don’t want the connections, you can just delete them, after the fact.
You can also use a network folder to save your settings to, and have both installs read from the same location.
Thank you, Jeff. That did the trick. I’ll also check out the network folder option as that would really make life easy.
Hi Jeff,
Dumb question here. 🙂 I’m on Data Modeler 4.0.2 and I am trying to set up my naming conventions. The issue is, I cannot find the relevant option in the menu – neither in Tools > Preferences, nor anywhere else. Could you please point me?
Thanks,
Kirill
Right click on the Design in the tree, design properties, Settings, Naming Standard.
This way the standards you set live on with your design and will be there when someone else opens it.
I have been trying to edit naming standards using Oracle SQL Developer Data Modeler and the Preferences menu does not contain “Settings”, nor any “Naming Rules” … I would like to edit some of the naming rules and conventions for Surrogate/Foreign key relationships and so forth. Is there an add-in I am missing?
Ash
Look in the design properties – right click on the design in the tree.
I have been trying to edit naming standards using Oracle SQL Developer Data Modeler and the Preferences menu does not contain “Settings”, nor any “Naming Rules” … I would like to edit some of the naming rules and conventions for Surrogate/Foreign key relationships and so forth. Is there an add-in I am missing?
[Update} My Bad – I got it once I opened an actual Design, Properties and saw the naming standards … It is logical now that I understand that the standards relate to a design, not to the installation as a whole.
This is a fantastic product! I would now like to learn to script … is there a guide?
I’m trying to create a candlestick graph in sqldeveloper, but having a very hard time… Not sure if the query format or what! I’m trying to present one candlestick by term. Let’s say, 5 terms, and 5 candlesticks. Each term would have 4 points: 25th percentile ACT score (open), min act (low), max act (high) and 75th percentile ACT (close). I’ve tried creating the query in a matrix format (5 rows, each row with the above info – 5 columns:term and the 4 data points), and also tried a long query (20 rows, 3 columns: term, act_label, act_value). With this data I can create nice bar charts, and even a nice radar chart, but not the cool candlestick I’m after. Has anyone done a candlestick chart, and what would the query, setup look like? Thanks!!
Give me a sample query, say against scott.emp or hr.employees and what you’d like candlesticked – and I’ll see what I can do 🙂
/* Here it is. Year would be my term, and sal is my ACT. How can I create one candlestick per year, showing the 4 values as points in the candlestick. Thank you!!
*/
select to_char(hiredate,’YYYY’) as year, min(sal) as min_sal, max(sal) as max_sal
, percentile_disc (0.25) within GROUP (ORDER BY sal) sal_25
, percentile_disc (0.75) within GROUP (ORDER BY sal) sal_75
from emp
group by to_char(hiredate,’YYYY’)
order by 1
right click on table only displays
Export
Spatial
Quick DDL
I’m guessing you have the rights to see this table – so something is really wrong here. Try re-installing the program.
I found the Open Object on Single Click checkbox in Database: ObjectViewer and it was checked. I unchecked it.
No difference in behavior that I could tell.
what about, right click, open?
I am on version 4.0.2.15 build 15.21.
When I select the table in the connections panel they data detail display does which contains the Columns, Data, Constraints, Grants, Statistics, Triggers, and so on does not appear. I can find now place to turn it on.
You probably have open object on single click disabled. Does double-clicking on the object work?
it does not work to double click. just expands/contracts the connection to show the columns.
can you let me know via email when this gets answered.