If you’re like me, you quickly got tired of scrolling down to the (lowercase) dbo object in your SQuirreL database browser every time you open the app. If you want to only see tables/views/procedures for “dbo” and save a lot of load time, right click on your Alias (e.g. “mydev”) in the left hand Aliases tab, select “Modify Alias”, hit the “Properties” button, then in the Schemas tab select “Specify Schema loading and caching”, change the Set [All Objects] in all Schemas to [Don’t load], hit “Apply”, then scroll to the “dbo” row and change the Tables, Views, and Procedures selections to “Load but don’t cache”. Hit Ok, then Ok. Now every time you connect to your database, you will only see the dbo object under your database object and the schema will load a lot faster.
Don't miss a thing!
Sign up for free email updatesCategories
- Code (38)
- Android (1)
- ASP.NET MVC (35)
- Jquery (8)
- Python (2)
- Dev Life (20)
- Dev Tools (24)
- Management (9)
- Miscellaneous (9)
- Online Learning (3)
- Science! (20)
- Code (38)
Browse articles by tags
3d printing agile management ai ajax ambient power Android artificial general intelligence artificial intelligence ASP.NET ASP.NET MVC best practices big data c# caching cmd Console2 csharp dev tools Editor Templates html javascript jquery jquery.UI Kinect machine learning management open source Powershell Productivity project management python quantum computer quantum computing radio power rdlc report viewer rf power sarcasm sensors stanford unit testing university Visual Studio wireless power xml
