ThatJeffSmith

Tag: Schema

30 SQL Developer Tips in 30 Days, Day 6: Try the Schema Browser

I’m at a friend’s house, sans laptop, so today’s post will be short and sweet. Also, no pictures! In your connection tree, on an active (connected) connection, right-click and select the Schema Browser. If you hop around users/schemas frequently in a database, you may enjoy the drop-down control for toggling.

Toad for Oracle Tip: Custom Queries

There are SO many little nuggets in Toad that you can take advantage of. To list all of them would be a daunting task. Here’s one that you may have overlooked, Custom Queries. If you right-mouse-click on an object in the Schema Browser, you’ll see a list of operations you can perform. Take a second […]

INTRODUCING TOAD FOR SQL SERVER PT III

Up to this point, I have demonstrated my mastery of the Roman Numeral System, Toad’s IntelliSense and Group Execute technology, and Toad’s SQL Optimization technology. In this post I’ll finish the conversation with an overview of Toad’s Compare and Synch feature set. For your reading enjoyment and my time constraints and sanity, I will show […]