The Microsoft JDBC driver, version 2.1.2828, provide all the SCHEMA on the JDBC interface. More precisely, said a DatabaseMetaData.getSchemas (), not all schema of an SQL server. Especially notable was the work when using DbVisualizer Free and the MS SQL Server 2005. Because of this behavior I had contact with the Ming be autonomous (manufacturer of DB Visualizer). I then received this reply:

Catalogs and schemas in DbVisualizer Free are retrieved by asking the JDBC driver to return them.

DbVisualizer Personal use its own SQL to fetch schema information.

Here's an example with the AdventureWorks sample database from Microsoft:

The support staff of Minq then gave me the hint that this is known at Microsoft, and the behavior is not caused by DbVisualizer: MS JDBC driver error , the driver 1.2.2828 is the latest version of the SQL Server 2005. The message in the forum is from January 2008! Since no bug fixing?

There is also the Microsoft SQL Server JDBC Driver 2.0 (2009 Jan) as a community technology preview , this also allows a connection to SQL Server 2005 and is JDBC 4.0 compliant if the version of Java 6 is used.

After a test set out at me too so wide disillusionment. As the screenshot below shows, the behavior is identical:

Unfortunately, this also provides brand-new driver is not correct SCHEMA. What makes because Microsoft? What is so difficult an accurate list of SCHEMA's return?