Start a new topic

Default schema in sql commander

Hello.  Any chance we can have an option for connections to have an override schema. For example, for my Sybase connections, I want some to default to 'dbo', regardless of the ID that was used to login and others to some other schema.. etc.. Thanks

1 Comment

The schema that is selected by in an SQL Commander tabs depends on a number of criteria. 


1) If the focus is in an SQL Commander tab and you open a new, it gets the same selections for Database Connection, Database and Schema as the one that had the focus,


2) If no SQL Commander has the focus and you have a schema node, table node or similar database object selected in the tree, a new SQL Commander gets the corresponding Database Connection, Database and Schema selected,


3) If none of the above is true, and you have a connection node selected, the settings in the Properties tab for the connection under the SQL Commander category determines the selection for the Database and Schema: the connection default, none or the most recently used.


I hope this helps you get what you're asking for.


Best Regards,

Hans

Login or Signup to post a comment