Re: How to default to dbo?

On 7/28/07, Hans Loeblich <hloeblich@xxxxxxxxxxxxxxxxxx> wrote:
> I am just trying out SQuirreL SQL for the first time, and noticed that
> it behaves differently than some other database management tools I am
> accustomed to.
>
> I am logging in to a MS SQL Server database, using the jTDS driver, as
> user "hloeblich".  At the top level, I see the list of catalogs(i think
> this is the word), and I can choose one.  After choosing a catalog, it
> looks like I am seeing a list of all usernames.  The problem is that
> there is nothing under any of the usernames except for dbo.  It seems
> that other tools I have used would default to dbo, and not show the
> other folders(if i remember correctly, this whole heirarchy level is
> omitted, directly under catalog shows the tables, views, etc.
> directories).  Is there some way I can make SQuirreL behave this way.
> Please forgive me cause I don't completely understand the user
> permissioning, etc.  I did not set up this database, I just have limited
> access under my username/login.

There isn't a way to collapse this hiearchy.  The driver tells
SQuirreL that a particular table that you see in the tree is in the
<username> catalog, and that the it's schema is "dbo".  Theses two
pieces of information are required to fully qualify a tablename in
SQLServer.  SQuirreL's object tree mirrors the information given by
the driver for the database.  You can however add a filter to remove
the unused schemas from the tree.  Simply right-click on the top-level
node and choose "Edit Objects Filter".  Then type "dbo" in the schema
filter textfield.

Rob

-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/