|
| An easy way to develop in MySQL |
|
A powerful GUI tool that helps in faster database and application development by simplifying routine database administrative tasks |
| Rahul Sah |
|
|
| Thursday, July 05, 2007 |
|
|
|
DB browsing and editing
Toad's Database Browser lets you view, create, modify, and manage database objects. From the Database tab of the browser we can create, alter and drop databases. Creating a database and then its tables is just a walk through. While creating tables is just a form-based process through which we can add columns, constraints and also view the tables' SQL script code. Through this Database Browser window other database objects like views, procedures, functions, triggers, users, etc can also be viewed, created, modified and managed. To create views or procedures use the SQL Editor window. This editor allows creating, executing, modifying and saving queries, viewing and editing data, and processing DDL commands from an easy-to-use interface. The auto-completion of SQL statements and highlighting of syntaxes makes it convenient and faster to develop SQL queries, triggers and procedures. In the Editor window, the output for a statement gets displayed in a multi-tabbed Script Results window, with one grid per SELECT statement. Also while in editor window if you are not able to locate the cursor, just press the Escape key, a beacon will highlight the cursor.
SQL Modeler
This is another productive feature of Toad for MySQL. This modeler can be used to quickly create the framework of an SQL query using a graphical interface. Using it, you can select tables and views, join or select columns, and add conditions to the statement. You can also execute and send the statement to the Editor, save the model to a file, and print the model.
|
|
|
The IT Green Book: A CIOL Initiative
Eco-friendly IT process not only makes a good environment sense, but also a very good business sense. Join us in this initiative that protects nature and your business.
know more..
|
|
