|
From: Robert M. <rob...@gm...> - 2007-07-28 11:08:10
|
On 7/28/07, Hans Loeblich <hlo...@kp...> 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 |
