Home » DbVisualizer Forums » DbVisualizer » DbVisualizer - Support

Thread: Sybase ASE - Set Current Schema

This question is not answered. Helpful answers available: 2. Correct answers available: 1.


Permlink Replies: 1 - Pages: 1 - Last Post: May 12, 2011 8:35 PM Last Post By: Hans Bergsten Threads: [ Previous | Next ]
KSY

Posts: 1
Registered: 05/12/11
Sybase ASE - Set Current Schema
Posted: May 12, 2011 7:55 PM
 
   thread.click_reply Reply
 global.attachment Sybase_ASE.png (49.3 KB )

Environment:
DbVisualizer Personal 7.1.4
Sybase ASE 12.5.4
jConnect JDBC Driver 6.05

Issue:
Can you please let me know if there is a way to:

  • Change the current schema automatically
or
  • Not set the current schema at all

I know I can manually change the current schema from the drop-down list in the SQL Commander, but I was wondering if this can be set automatically when I log in.

In Tool Properties --> Sybase ASE --> Set Current Schema --> This feature is disabled for Sybase

Hans Bergsten


Posts: 1,582
Registered: 10/11/06
Re: Sybase ASE - Set Current Schema
Posted: May 12, 2011 8:35 PM    global.in_response_to.tooltip in response to: KSY
 
   thread.click_reply Reply
Hi,

This feature is disabled for Sybase ASE because, as far as I know, there is no SQL command to set the current schema for this database type, as there is for some other databases (e.g. "ALTER SESSION SET current_schema" for Oracle). If you have found documentation for a SQL command that does this, please post a URL that describes it.

Best Regards,
Hans

Point your RSS reader here for a feed of the latest messages in all forums