Re: How to default to dbo?

Thank you, that helps a lot.  Very nice feature. 

I do still have a few of gripes(feature requests) because I think this 
feature could be made much more useful.

1. Limiting Catalog Objects by prefix is not the optimal solution for 
me.  For example, I have a catalog "ABC", and "ABC_BAK".  If I only want 
to see ABC, there is no way to do this.
I think what would be much more powerful, and probably not too difficult 
to implement would be the option to use regular expressions.  Or even 
just a glob matcher (eg "ABC*" to denote anything with a "ABC" prefix).  
You could still do comma delimited globs even. 
This would be good to use for limiting schemas too, but it doesn't 
affect me personally since I only need to see "dbo" (and luckily no 
other schemas begin with dbo).  I think that whatever the final 
decision, a *consistent* form of limiting for all three filters here 
would be a good thing.

2. The object filter is a nice touch, but ideally I would like to limit 
objects differently per catalog.  All the important tables in one of my 
catalogs have a specific prefix, so I thought I could put this to good 
use.  But in another catalog, there is no particular prefix on any of 
the tables.  So if I limit it for the first catalog, then all my tables 
are gone in the second catalog.  This makes this feature useless in my 
particular case.

3.  The object filter seems to implement a sort of glob search, but why 
were "%" and "_" chosen?  In my experience, the standard characters are 
usually "*" for zero or more of any character, and "?" to match any one 
character.  The main problem I see with this is that "_" is a valid(and 
very commonly used) character for a table name.

Would these suggestions be better posted to the dev list?

-Hans


Robert Manning wrote:
> 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/