Hello, data people. My name is Robert Pound, and I am a product technologist at Quest. This video covers the basics of accessing objects and working with worksheets in Toad Edge.
So with the tool open, I can open a new worksheet by clicking on the Worksheets button in the toolbar. This has opened a worksheet with the connection that was in focus at the time, which was root localhost. If this was not the correct connection, in the toolbar, in the tab, I could use the dropdown menu and select a different connection. And you can see the work sheet has moved.
I will move back to localhost. And in the worksheet itself I will start typing, and it gives me intelligent feedback for the objects that I have for this connection. So in this case, I want to select from the world database, and I want to choose the country. And you can see it's starting to alias the fields themselves.
So for instance, continent, it's changed it to a table aliased form of c. and then Continent. So if I choose comma and then again do c., it's going to give me a list of the columns that I have available to me. And I'll choose a couple more.
And then we will select from-- and it's filling it in for me. So I simply have to hit Enter to get the SQL statement filled out. And if at any time I can't get the context menu up, I can choose Control-Space and it will bring it up for me.
So in the toolbar we have different options for executing. Since this is a simple statement, I will choose the Execute SQL Statement. And now we have results. If that was a long running query, I could obviously have clicked Stop or Cancel Query if there were errors.
The Commit and Rollback Transaction buttons are grayed out. That is because we have auto commit selected. So to get rid of auto commit, if you wanted to commit manually, you could come to Databases and choose Disable Auto Commit, or in the Properties, you can also disable auto commit for the connection. We also have the ability to either hide the results pane or move it vertically or horizontally, depending on our preferences.
So before I leave worksheets, let's talk quickly about formatting code. So if this was a piece of code that I wanted to store and save, I could come first to Edit and choose Format to stylize the code and make it more appealing. And then I could come to the File and choose Save to save it for running later.
Now that we've seen worksheets, let's move on to accessing objects. So if I wanted to take a look at the object that we were just querying-- in this case, country-- I could, in the Object Explorer, double-click on this object, and it will open up a separate tab, giving me information on this table. So you can see column and column attributes, indexes, constraints. You get sample data as well and some of the information as far as creating this table again, statistics, et cetera.
Now, if we wanted to investigate the objects for this entire connection, in the Object Explorer, we could choose this button to display open objects. With that selected, now if I click on a different object-- for instance, the database-- it will update the Details pane to show all the information for that object. If I go to another database and I choose Views and then expand out, it will give me information about the separate views, stored procedures, et cetera.
Now, any object I touch in the Object Explorer will update this tab. If I no longer want to see this, I can come back and de-select it. I hope this video was helpful. For more information on this product preview, search for Toad Edge on www.toadworld.com. For the upcoming full release of the product coming later this year, check out www.quest.com. Thank you, and have a great day.
04:58