The Function browser 8. The Parameter Browser 8. The Transaction Browser 8. The Script Debugging Buttons 8. The Script Area 9. Entering and Editing Queries Manually 9. Building Queries 9. Creating Views 9. Exporting Result Sets 9. Comparing Result Sets 9. Editing Queries From a Development Tool 9. Using the Regex Text Importer Tool Introduction The Main Editor Window The Column Editor The Detail Area The Table Options Tab The Various Section The Row Options Section The Storage Options Section The Merge Table Options Section Applying Your Changes General Options SSL Connections Editors Display Options Query Options Various A.
Introduction A. Downloading The Source Code A. Prerequisites A. Compiling and Building A. Building Static Binaries A. Building RPMs B.
Troubleshooting Connection Errors B. Troubleshooting Display Problems C. How Connections Are Stored D. Notes for Translators G. PNG Support. The Script Editor 8. The File Open Dialog 9. The Table Tool 9. Stored Procedure in Database Browser Enter the name of the host on which the database server resides, together with appropriate user and password credentials.
Finally, specify the name of database in the Default Schema field on which you wish to work during the Query Browser session note that you can switch to a different database later from within the tool. Click on the Connect button to connect to the specified server.
At the top of the window is a large text input field. This is where SQL statements are typed by the user. Statements can be entered on multiple lines and are not executed until the execute button is pressed the round green button with the white lightning bolt. An executing statement can be stopped by pressing the red stop button. The Back and Next buttons provide a way to page through the history of executed commands.
The large gray area in the center of the screen displays the results of the executed statements. An additional section at the bottom of the window appears to display any errors encountered as a result of a SQL statement. In the top right hand side of the window is a list of databases available on the server to which the tool is currently connected.
Clicking the arrow next to any database will display the tables contained therein. Clicking on the arrow next to a table will similarly list the columns in that table. Right clicking with the mouse in this area pops up a menu providing options to create new tables, views and databases.
This menu also provides an option to select a different schema to the one chosen at the login screen and provides the option to drop the currently highlight table or database.
The bottom right side of the main window provides a list of help topics. Double clicking on a list item will display help text in the result area of the screen.
0コメント