Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

For most databases, the schema selected in the Schema list is used only to limit the tables the Auto-Completion feature shows in the completion pop-up; it does not define a default schema for tables referenced in the SQL since most databases do not allow the default schema to be changed during a session. 

For the databases that do allow the default schema to be changed*, the selected schema is also used as the default schema, i.e., the schema used for unqualified table names in the SQL. If the Database Type is set to Generic for a connection, DbVisualizer tries to set the default schema (if Use Schema is chosen) but it depends on the JDBC driver if this works or not.

...